Accessing Index Server from SQL Server on different system

Hi
I have SQL Server and Index Server running on 2 different system.
How can I call Index server from SQL Server (store procedure) in such
case.
Regards

> Hi
> I have SQL Server and Index Server running on 2 different system.
> How can I call Index server from SQL Server (store procedure) in such
> case.
> Regards
You can connect use the OLE DB Provider for Microsoft Indexing Service to
connect to the remote Index Server. More info:
http://msdn.microsoft.com/library/de...us/acdata/ac_8
_qd_12_0h0l.asp
Eric Crdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Accessing Index Server from SQL Server on different system

Hi
I have SQL Server and Index Server running on 2 different system.
How can I call Index server from SQL Server (store procedure) in such
case.
Regards
> Hi
> I have SQL Server and Index Server running on 2 different system.
> How can I call Index server from SQL Server (store procedure) in such
> case.
> Regards
--
You can connect use the OLE DB Provider for Microsoft Indexing Service to
connect to the remote Index Server. More info:
http://msdn.microsoft.com/library/d...-us/acdata/ac_8
_qd_12_0h0l.asp
Eric Crdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Accessing Index Server from SQL Server on different system

Hi
I have SQL Server and Index Server running on 2 different system.
How can I call Index server from SQL Server (store procedure) in such
case.
Regards> Hi
> I have SQL Server and Index Server running on 2 different system.
> How can I call Index server from SQL Server (store procedure) in such
> case.
> Regards
--
You can connect use the OLE DB Provider for Microsoft Indexing Service to
connect to the remote Index Server. More info:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8
_qd_12_0h0l.asp
--
Eric Cárdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

accessing from T-SQL a database on another DBMS

tHi
I want to build a trigger to modify data in a table in a database that is
running on another Database Engine in may LAN. I don' t know if that is
possible. If it is, how will I make the connection to that database?
Thanks in advance - WaldoYou would have to set up the other instance as a "linked server". But what you want to do requires a
distributed transaction (with DTC running and all that jazz) so I would re-think the approach if
possible.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"wvandenbroeck" <wvandenbroeck@.discussions.microsoft.com> wrote in message
news:2A416FD1-02F9-427D-9748-7F2CE4E08CDD@.microsoft.com...
> tHi
> I want to build a trigger to modify data in a table in a database that is
> running on another Database Engine in may LAN. I don' t know if that is
> possible. If it is, how will I make the connection to that database?
> Thanks in advance - Waldo|||I concur. Consider some form of asynchronous mechanism where by you put the
requisite information in a queing table and pull from the other db engine to
do the updates.
You can get DTC to do what you need however, but it is often a PITA. :)
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eh02e1bLIHA.4684@.TK2MSFTNGP06.phx.gbl...
> You would have to set up the other instance as a "linked server". But what
> you want to do requires a distributed transaction (with DTC running and
> all that jazz) so I would re-think the approach if possible.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "wvandenbroeck" <wvandenbroeck@.discussions.microsoft.com> wrote in message
> news:2A416FD1-02F9-427D-9748-7F2CE4E08CDD@.microsoft.com...
>> tHi
>> I want to build a trigger to modify data in a table in a database that is
>> running on another Database Engine in may LAN. I don' t know if that is
>> possible. If it is, how will I make the connection to that database?
>> Thanks in advance - Waldo
>

Accessing config file from delivery extension

I'm running into a problem with reading a config file with my own custom
entries in it from within a delivery extension. I've tried putting it in the
ReportServer web.config and RSReportServer.config, and my code doesn't seem
to be able to find it.
When I use the configuration file .Net framework classes from within a
delivery extension, which config file is it looking at?
Thanks,
Mike SandwickMike,
Subscriptions are run in an unattended mode by the Report Server Windows
service (ReportingServicesService.exe) not the Report Server. So, try
putting your config settings in ReportingServicesService.exe.config.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Mike Sandwick" <MikeSandwick@.discussions.microsoft.com> wrote in message
news:8BF4DD62-2EBE-491E-AB21-12BCFF53AA8E@.microsoft.com...
> I'm running into a problem with reading a config file with my own custom
> entries in it from within a delivery extension. I've tried putting it in
the
> ReportServer web.config and RSReportServer.config, and my code doesn't
seem
> to be able to find it.
> When I use the configuration file .Net framework classes from within a
> delivery extension, which config file is it looking at?
> Thanks,
> Mike Sandwick|||Hi Teo:
The delivery extension also has to provide GUI functionality in the
Report Server process, which will pull settings from
RSWebApplication.config. Depending on when the settings are used -
they might have to appear in both.
--
Scott
http://www.OdeToCode.com/
On Tue, 5 Oct 2004 21:57:50 -0400, "Teo Lachev [MVP]"
<teo.lachev@.nospam.prologika.com> wrote:
>Mike,
>Subscriptions are run in an unattended mode by the Report Server Windows
>service (ReportingServicesService.exe) not the Report Server. So, try
>putting your config settings in ReportingServicesService.exe.config.|||That was it, I put my configuration file entry in the
ReportingServicesService.exe.config, and it now works.
Thanks!
Mike
"Teo Lachev [MVP]" wrote:
> Mike,
> Subscriptions are run in an unattended mode by the Report Server Windows
> service (ReportingServicesService.exe) not the Report Server. So, try
> putting your config settings in ReportingServicesService.exe.config.
> --
> Hope this helps.
> ----
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Mike Sandwick" <MikeSandwick@.discussions.microsoft.com> wrote in message
> news:8BF4DD62-2EBE-491E-AB21-12BCFF53AA8E@.microsoft.com...
> > I'm running into a problem with reading a config file with my own custom
> > entries in it from within a delivery extension. I've tried putting it in
> the
> > ReportServer web.config and RSReportServer.config, and my code doesn't
> seem
> > to be able to find it.
> >
> > When I use the configuration file .Net framework classes from within a
> > delivery extension, which config file is it looking at?
> >
> > Thanks,
> > Mike Sandwick
>
>|||Scott,
You are right. In general, a custom extension should store its config
settings in the Configuration element in the RSWebApplication.config. This
will allow the Report Server (or Report Manager) to push these settings to
the extension.
Perhaps, I should have started my reply with this side note. I assumed that
in Mike's case this wasn't acceptable. Thanks for pointing this out.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:6g07m0ttch61feklpro0dueks5a301o6d7@.4ax.com...
> Hi Teo:
> The delivery extension also has to provide GUI functionality in the
> Report Server process, which will pull settings from
> RSWebApplication.config. Depending on when the settings are used -
> they might have to appear in both.
> --
> Scott
> http://www.OdeToCode.com/
> On Tue, 5 Oct 2004 21:57:50 -0400, "Teo Lachev [MVP]"
> <teo.lachev@.nospam.prologika.com> wrote:
> >Mike,
> >
> >Subscriptions are run in an unattended mode by the Report Server Windows
> >service (ReportingServicesService.exe) not the Report Server. So, try
> >putting your config settings in ReportingServicesService.exe.config.
>

Accessing ASPNETDB from outside web application

Hi there,

I have a slight problem. I have a web service running on my server. In this, I need to access values in User's profiles. The problem is of course, that Profile, ProfileCommon, ProfileBase, etc... are not available to me here.

What can I do?

Is using an SQL command best? If so, could someone post an example SQL command - I am getting confused by how to structure the command, since I need Membership data like UserName, and Profile data (an object serialized as binary in the Profile).

Kind regards,

kreid

Hi Kreid,

To share the ASPNETDB to another application, you will need to attach the database to an instance of SQL Server. Then change the connection string of both applications to point to that database.

|||

Hi Kevin,

I'm having the sampe problem even though I have my ASPNETDB in an SQL-server. After thoroughly checking the interfaces, and forums, there is apparently no way to access the Profile from a console application. Certainly, I can do a LINQ query and get the Profile properties string and values string from the ASPNETDB, but then parse them myself etc.? There must be a better way? Any tips/examples out there?

Thanks!

Richard

|||

The Solution:

http://blogs.msdn.com/msdnts/archive/2006/12/16/asp-net-2-0-membership-role-management-out-of-asp-net-context.aspx

Accessing Active Directory using SQL Server 2000

Hello All,

I have a linked ADSI Server to our company Active Directory and
everything is fine. I'm running queries and such using LDAP. BUT how
can I aquire a list of attributes for the classes and categories. Such
as if i wanted to see a user's telephone number and email address for
use in a corporate database? Is this possible?

ThanksHi

I have never tried this.. but...:

The example of ADSI in books online returns the SN and ST attributes of the
contact class. See Books Online:

mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd
ata.chm::/ac_8_qd_12_94fn.htm

You should then be able to use the same OPENQUERY as the destination of the
update statement. See Books Online:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_oa-oz_5xix.htm

John

"Brandon Arnold" <btugg@.yahoo.com> wrote in message
news:8508d156.0312301444.b04f4c8@.posting.google.co m...
> Hello All,
> I have a linked ADSI Server to our company Active Directory and
> everything is fine. I'm running queries and such using LDAP. BUT how
> can I aquire a list of attributes for the classes and categories. Such
> as if i wanted to see a user's telephone number and email address for
> use in a corporate database? Is this possible?
> Thanks|||Thanks John but I'm looking a little deeper than that.

While searching yesterday I ran across another attribute that is
usually shown
in sample LDAP queries and it was "sAMAccountNAme" which is the
account a user may log on with. I'm for a list of attributes for
Computers, People, etc in Active Directory. Is there such a list or
definition table?

"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<ibyIb.2549$le.23310381@.news-text.cableinet.net>...
> Hi
> I have never tried this.. but...:
> The example of ADSI in books online returns the SN and ST attributes of the
> contact class. See Books Online:
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd
> ata.chm::/ac_8_qd_12_94fn.htm
> You should then be able to use the same OPENQUERY as the destination of the
> update statement. See Books Online:
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
> lref.chm::/ts_oa-oz_5xix.htm
> John
> "Brandon Arnold" <btugg@.yahoo.com> wrote in message
> news:8508d156.0312301444.b04f4c8@.posting.google.co m...
> > Hello All,
> > I have a linked ADSI Server to our company Active Directory and
> > everything is fine. I'm running queries and such using LDAP. BUT how
> > can I aquire a list of attributes for the classes and categories. Such
> > as if i wanted to see a user's telephone number and email address for
> > use in a corporate database? Is this possible?
> > Thanks|||As in ?:
http://msdn.microsoft.com/library/d...ace_mapping.asp

John

"Brandon Arnold" <btugg@.yahoo.com> wrote in message
news:8508d156.0312310700.647abcfb@.posting.google.c om...
> Thanks John but I'm looking a little deeper than that.
> While searching yesterday I ran across another attribute that is
> usually shown
> in sample LDAP queries and it was "sAMAccountNAme" which is the
> account a user may log on with. I'm for a list of attributes for
> Computers, People, etc in Active Directory. Is there such a list or
> definition table?
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:<ibyIb.2549$le.23310381@.news-text.cableinet.net>...
> > Hi
> > I have never tried this.. but...:
> > The example of ADSI in books online returns the SN and ST attributes of
the
> > contact class. See Books Online:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd
> > ata.chm::/ac_8_qd_12_94fn.htm
> > You should then be able to use the same OPENQUERY as the destination of
the
> > update statement. See Books Online:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
> > lref.chm::/ts_oa-oz_5xix.htm
> > John
> > "Brandon Arnold" <btugg@.yahoo.com> wrote in message
> > news:8508d156.0312301444.b04f4c8@.posting.google.co m...
> > > Hello All,
> > > > I have a linked ADSI Server to our company Active Directory and
> > > everything is fine. I'm running queries and such using LDAP. BUT how
> > > can I aquire a list of attributes for the classes and categories. Such
> > > as if i wanted to see a user's telephone number and email address for
> > > use in a corporate database? Is this possible?
> > > > Thanks|||Yes! Thanks John!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<L_TIb.3630$5X.31045680@.news-text.cableinet.net>...
> As in ?:
> http://msdn.microsoft.com/library/d...ace_mapping.asp
> John
> "Brandon Arnold" <btugg@.yahoo.com> wrote in message
> news:8508d156.0312310700.647abcfb@.posting.google.c om...
> > Thanks John but I'm looking a little deeper than that.
> > While searching yesterday I ran across another attribute that is
> > usually shown
> > in sample LDAP queries and it was "sAMAccountNAme" which is the
> > account a user may log on with. I'm for a list of attributes for
> > Computers, People, etc in Active Directory. Is there such a list or
> > definition table?
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:<ibyIb.2549$le.23310381@.news-text.cableinet.net>...
> > > Hi
> > > > I have never tried this.. but...:
> > > > The example of ADSI in books online returns the SN and ST attributes of
> the
> > > contact class. See Books Online:
> > > mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd
> > > ata.chm::/ac_8_qd_12_94fn.htm
> > > > You should then be able to use the same OPENQUERY as the destination of
> the
> > > update statement. See Books Online:
> > mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
> > > lref.chm::/ts_oa-oz_5xix.htm
> > > > John
> > > > "Brandon Arnold" <btugg@.yahoo.com> wrote in message
> > > news:8508d156.0312301444.b04f4c8@.posting.google.co m...
> > > > Hello All,
> > > > > > I have a linked ADSI Server to our company Active Directory and
> > > > everything is fine. I'm running queries and such using LDAP. BUT how
> > > > can I aquire a list of attributes for the classes and categories. Such
> > > > as if i wanted to see a user's telephone number and email address for
> > > > use in a corporate database? Is this possible?
> > > > > > Thanks

Accessing 2 databases on the SQL server through ASP.net

Hi everyone,

First of all I'd like to say I'm new to the forums, and in fact new to ASP.net.

I've had a couple of applications running in VB.net for the last year or so that I now am looking to move on and into ASP.net (main reason is to do with implementation to remote sites in foreign countries).

I'm currently following through the "Working with data and ASP.net 2.0" walkthrough on this site, which I must say has been a great help.

I'll start with the background stuff first

I have my main database on an SQL server. I also have 2 other databases on there - Customer and Employee. The reason for these are that they are shared amongst my VB applications and I kept them as seperate databases so that one database is all that needs to be administered and maintained, and these changes are then seen on both apps (takes away redundant data as well).

In my main database, main table, is a field called CustomerID. This value relates to the CustomerID in the Customer table. In my VB app all I do is have the user select a customer name, and then the customer ID value is copied to the CustomerID field of my main table when inserting / updating a row. This is simply accomplished with 2 SQL connections and 2 dataAdapters. I also use 2 dataSets - one for Customer, one for WorkRequests (the main database)...

I use ComponentOne stuff so that my grid will show the CustomerName instead of the CustomerID etc, and the same applies when I use my Employee database - I run many dataAdapters to this for things such as Account Manager, Technologist, Creator, UpdatedBy etc etc.

Now, I'm new to VS 2005 - my apps were created in VS 2003 and .net 1.1. Can I easily re-create my apps in ASP.net? My primary goal at the moment is to make sure I can load a row, and display the "lookup" values instead of the "integer" value. As my tables are in seperate databases, I would like to know the best way of accomplishing this, if it is of course possible.

Help and advice much appriciated.

Kind Regards,

Luke

SQL supports 4-section object name, in?the?format?of?server.database.owner_name.object_name,?so?just?add?database?part?when?you?want?to?refer?to?object?in?other?database.?For?more?information,?please?refer?to:?Using Identifiers as Object Names|||

Thank you very much, you reminded me about that, I think I looked into it ages ago but then put it to the back of my mind.

To display my CustomerName field by linking to the CustomerID field I'm using;

SELECT npd_dwr.dbo.dwr.dwrnumber, npd_dwr.dbo.dwr.customerid, customerdb.dbo.customer.customername
FROM npd_dwr.dbo.dwr
INNER JOIN customerdb.dbo.customer ON npd_dwr.dbo.dwr.customerid = customerdb.dbo.customer.customerid

Thanks again,

Regards

Access: linked tables invisible

I've recently moved a database from mssql2000 on an NT Server machine
to mssql2000 running on a Win 2003 Server machine.
Now, when I try to use Access 2002 to Link an sql table, the Access
wizard isn't showing any of the sql tables. In fact, it only shows a
couple of the system tables: dbo.sysconstraints & dbo.syssegments and
one of the views in the database.
I'm using odbc to connect Access to the SQL Server. Everyting else
seems to work ok.
Could anyone suggest whats wrong here, or how to go about finding out
whats wrong?
regards
Richard
On Fri, 06 May 2005 09:01:29 +0100, Richard <richard@.softmode.net>
wrote:
mssql2000 running on a Win 2003 Server machine.
>Now, when I try to use Access 2002 to Link an sql table, the Access
>wizard isn't showing any of the sql tables. In fact, it only shows a
>couple of the system tables: dbo.sysconstraints & dbo.syssegments and
>one of the views in the database.
>
Problem solved by installing latest mdac on workstation.
Richard

Access: linked tables invisible

I've recently moved a database from mssql2000 on an NT Server machine
to mssql2000 running on a Win 2003 Server machine.
Now, when I try to use Access 2002 to Link an sql table, the Access
wizard isn't showing any of the sql tables. In fact, it only shows a
couple of the system tables: dbo.sysconstraints & dbo.syssegments and
one of the views in the database.
I'm using odbc to connect Access to the SQL Server. Everyting else
seems to work ok.
Could anyone suggest whats wrong here, or how to go about finding out
whats wrong?
regards
RichardOn Fri, 06 May 2005 09:01:29 +0100, Richard <richard@.softmode.net>
wrote:
mssql2000 running on a Win 2003 Server machine.
>Now, when I try to use Access 2002 to Link an sql table, the Access
>wizard isn't showing any of the sql tables. In fact, it only shows a
>couple of the system tables: dbo.sysconstraints & dbo.syssegments and
>one of the views in the database.
>
Problem solved by installing latest mdac on workstation.
Richard

Access XP Versus Access 2000

I have sql server running on my pc at on its on a different partition with Windows Server 2000 running SQL Server 2000 I'm using Access XP on the front end and I am finding that SQL can get Xp to sit up Beg Fetch you name it with no Problems at all...But Access 2000 BIG PROBLEM its like its too dump to understand. I get too many error messages with access 2000. I can hardly wait until they rolll out office xp at workLike what?

Want some laughs...I got some Access 2.0 disks here...

Access to several SQL Servers implementing trusted connection

Being an IT consultant, I have to visit a number of customers having applications running on SQL Servers that implement trusted connection security model. In addition, all of these companies have their own DOMAIN settings, and security implementation.

How can I access to databases without changing the DOMAIN settings of MY notebook? I do not want them to switch to SQL security model, and I do not want to create any security hole in those companies.

What shall I want from the system administrator so that I can login into their domain without changing my domain settings?

Thanks,

EIO.

Hi,

you can store user network crednetials for your account on the notebook which will be used if connecting to a remote server.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

May I ask: How?

I understand that:

1. I have to ask all the administrators in those separate companies to create a user account for me, in their local domains, that has access to the SQL Server databases. That is easy.

2. I have to register those separate domain accounts in my notebook (how?)

3. After I connect to the company network and login to my notebook with my own username, those registrations will make me be acquainted with the company network.

Is this correct? And how can I complete Step 2?

Thanks in advance,

EIO.

|||

Yes you can ask those companies to create a standard account with your name and you can access the SQL Server using Enterprise manager by regsitering those instances. I have done this previously without any problem, where the account name (username) should match for authentication.

On Step2 even though it says cannot connect to server you can still register on your EM lists.

Access to another database via a stored procedure

I have a stored procedure on a database that selects information from
another database, and the users running the stored procedure are not users
on the 2nd database. I don't want to have to enter all users individually
into the 2nd database, I just want anyone who has execute rights to that
stored procedure to be able to select information from the 2nd database.
Do I have to somehow in the stored procedure log into the 2nd database as a
public user?
Right now I am getting errors that says the user is not a user of the 2nd
database. The 2nd database is a public database, so I shouldn't need to be
a user on it.Users need a security context in all databases accessed. If you don't want
to add users to the 2nd database, one method:
1) enable the 'guest' user in the second database (sp_adduser 'guest')
2) enable 'db chaining on both databases (sp_dboption 'DB2', 'db chaining',
true)
If you objects are objects are owned by 'dbo', both databases need to have
the same owner so that the dbo user ownership chain is unbroken. You can
execute sp_changedbowner, if necessary. No permissions need be granted to
guest. Guest permissions are limited to those granted to public.
Note that you should fully trust those users that can create dbo-owned
objects before you enable cross-database chaining ('db chaining'). If the
databases are owned by 'sa', ensure only symin role members should have
permissions to create db-owned objects.
Hope this helps.
Dan Guzman
SQL Server MVP
"et" <eagletender2001@.yahoo.com> wrote in message
news:eO3CPC1AGHA.4080@.TK2MSFTNGP14.phx.gbl...
>I have a stored procedure on a database that selects information from
>another database, and the users running the stored procedure are not users
>on the 2nd database. I don't want to have to enter all users individually
>into the 2nd database, I just want anyone who has execute rights to that
>stored procedure to be able to select information from the 2nd database. Do
>I have to somehow in the stored procedure log into the 2nd database as a
>public user?
> Right now I am getting errors that says the user is not a user of the 2nd
> database. The 2nd database is a public database, so I shouldn't need to
> be a user on it.
>|||Thanks so much, this is very helpful information. I think the guest account
will work just fine, as I agree that I don't think I want to do the cross
ownership until I see the need. Thanks.
Thanks!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OsaivR1AGHA.2512@.TK2MSFTNGP09.phx.gbl...
> Users need a security context in all databases accessed. If you don't
> want to add users to the 2nd database, one method:
> 1) enable the 'guest' user in the second database (sp_adduser 'guest')
> 2) enable 'db chaining on both databases (sp_dboption 'DB2', 'db
> chaining', true)
> If you objects are objects are owned by 'dbo', both databases need to have
> the same owner so that the dbo user ownership chain is unbroken. You can
> execute sp_changedbowner, if necessary. No permissions need be granted to
> guest. Guest permissions are limited to those granted to public.
> Note that you should fully trust those users that can create dbo-owned
> objects before you enable cross-database chaining ('db chaining'). If the
> databases are owned by 'sa', ensure only symin role members should have
> permissions to create db-owned objects.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "et" <eagletender2001@.yahoo.com> wrote in message
> news:eO3CPC1AGHA.4080@.TK2MSFTNGP14.phx.gbl...
>|||I'm glad you found the information useful.
Just to be clear, if you don't enable cross database chaining, you will then
need to grant SELECT permissions to guest (or public) in the second database
because the ownership chain is broken. This will effectively allow all
server users not already in the second database to select from the table
directly. This might be ok in your situation but I want to make sure you
are aware of the ramifications.
Hope this helps.
Dan Guzman
SQL Server MVP
"et" <eagletender2001@.yahoo.com> wrote in message
news:uh%23icI2AGHA.2788@.TK2MSFTNGP14.phx.gbl...
> Thanks so much, this is very helpful information. I think the guest
> account will work just fine, as I agree that I don't think I want to do
> the cross ownership until I see the need. Thanks.
> Thanks!
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:OsaivR1AGHA.2512@.TK2MSFTNGP09.phx.gbl...
>

access SQL Server on a different domain

Is there a way to access a SQL Server running on a different domain? I can access the same SQL Server from my machine, which is on a different domain using the ODBC connection, but when I try to access it using an application written in VB6.0 then I get the SQL Server does not exist error. I'm using the SQL Authentication method.If you have MDAC 2.6 or above, then TCP/IP is selected by default. Also check your Client Network Configuration.|||My MDAC is 2.7 and I'm using the TCP/IP connection. Also there is no Trusted connection between the two Domains.|||Trust does not matter for SQL, unless there is some kind of TCP filtering configured. It seems like in your case there is something else happening with your VB app. What are you using in it to connect? DAO, RDO, ADO, or direct ODBC API's?

Access Sql server 2005 from .net class library

I have Sql server 2005 running on a workgroup server and wish to access the
data from another workgroup server using direct sql access (ie not ODBC). Th
e
code to access the data is written in visual studio 2005 and is within a
class library DLL. I wish to use Windows Authentication between the two
servers, but am not clear how to set the user within the code. Do I need to
use Component Services (ie MTS) to do this?Just use regular connection string for Windows Authentication, you can find
the syntax at www.connectionstrings.com. Since you are in a workgroup, you
may have to use a mirrored account (same username/password on both
computers).
Roman
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
"lankylad" <lankylad@.discussions.microsoft.com> wrote in message
news:F4F155F9-1D2E-449F-A5FF-5FCD24CF1025@.microsoft.com...
>I have Sql server 2005 running on a workgroup server and wish to access the
> data from another workgroup server using direct sql access (ie not ODBC).
> The
> code to access the data is written in visual studio 2005 and is within a
> class library DLL. I wish to use Windows Authentication between the two
> servers, but am not clear how to set the user within the code. Do I need
> to
> use Component Services (ie MTS) to do this?|||No need for COM+/MTS. The important thing here is that the class library
has the capability to accept connection string parameters and switch them
when necessary. Refer to the Enterprise Application Block, particularly the
Dta Access Application Block for samples. As Roman mentioned, since you are
in a workgroup environment, mixed mode authentication is a bit simpler for
this - create the same account on both server and assign permissions for the
necessary securables
"Roman Rehak" <rrehak@.hotmail.com> wrote in message
news:%23peB3KqwHHA.4628@.TK2MSFTNGP02.phx.gbl...
> Just use regular connection string for Windows Authentication, you can
> find the syntax at www.connectionstrings.com. Since you are in a
> workgroup, you may have to use a mirrored account (same username/password
> on both computers).
> Roman
> --
> Roman Rehak
> http://sqlblog.com/blogs/roman_rehak
>
> "lankylad" <lankylad@.discussions.microsoft.com> wrote in message
> news:F4F155F9-1D2E-449F-A5FF-5FCD24CF1025@.microsoft.com...
>|||Thanks both.
www.connectionstrings.com shows that the format for a Trusted Connection in
SQLConnection (.NET) is:
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated
Security=SSPI;
Do I just add a "User Id" entry to the end of that?
"bass_player [SBS-MVP]" wrote:

> No need for COM+/MTS. The important thing here is that the class library
> has the capability to accept connection string parameters and switch them
> when necessary. Refer to the Enterprise Application Block, particularly th
e
> Dta Access Application Block for samples. As Roman mentioned, since you a
re
> in a workgroup environment, mixed mode authentication is a bit simpler for
> this - create the same account on both server and assign permissions for t
he
> necessary securables
>
> "Roman Rehak" <rrehak@.hotmail.com> wrote in message
> news:%23peB3KqwHHA.4628@.TK2MSFTNGP02.phx.gbl...
>
>|||lankylad (lankylad@.discussions.microsoft.com) writes:
> www.connectionstrings.com shows that the format for a Trusted Connection
> in SQLConnection (.NET) is:
> Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated
> Security=SSPI;
> Do I just add a "User Id" entry to the end of that?
No. User Id is for SQL Authentication. When you use Windows Authentication,
the presumption is that you are already logged into Windows. And if you
are logged in as MACHINE1\USER1, you cannot log into SQL Server as
MACHINE2\USER2, you can only connect to SQL Server with the Windows
user you are logged in as.
Note that to get Windows Authentication to work in a workgroup, you
need to take some precautions. First, the usernamd and password must be
the same on the two machines. Next, run gpedit.msc, and check
Computer Cnofiguration->Windows Settings->Security Settings->
Local Policies->Security Options->Network access: Sharing and Security
model for local accounts. This needs to be set to Classic for the scheme
to work.
Given all this trickery, SQL authentication may be a better option in a
workgroup.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks.
Since I'm writing the data access code in a Class Library DLL does that when
I'm using the class from a web application I have to use Anonymous login and
have that user set up on my sqlserver server with the same password?
"Erland Sommarskog" wrote:

> lankylad (lankylad@.discussions.microsoft.com) writes:
> No. User Id is for SQL Authentication. When you use Windows Authentication
,
> the presumption is that you are already logged into Windows. And if you
> are logged in as MACHINE1\USER1, you cannot log into SQL Server as
> MACHINE2\USER2, you can only connect to SQL Server with the Windows
> user you are logged in as.
> Note that to get Windows Authentication to work in a workgroup, you
> need to take some precautions. First, the usernamd and password must be
> the same on the two machines. Next, run gpedit.msc, and check
> Computer Cnofiguration->Windows Settings->Security Settings->
> Local Policies->Security Options->Network access: Sharing and Security
> model for local accounts. This needs to be set to Classic for the scheme
> to work.
> Given all this trickery, SQL authentication may be a better option in a
> workgroup.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||lankylad (lankylad@.discussions.microsoft.com) writes:
> Since I'm writing the data access code in a Class Library DLL does that
> when I'm using the class from a web application I have to use Anonymous
> login and have that user set up on my sqlserver server with the same
> password?
Web servers are not my area, but I guess that if you use integrated
security from a web server, then the Windows login under which the
web server runs is what will count. But it may be that an SQL login
is better in this case.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||All the advice from Microsoft seems to be to avoid mixed authentication, so
I
have been trying to use only Windows Authentication.
"Erland Sommarskog" wrote:

> lankylad (lankylad@.discussions.microsoft.com) writes:
> Web servers are not my area, but I guess that if you use integrated
> security from a web server, then the Windows login under which the
> web server runs is what will count. But it may be that an SQL login
> is better in this case.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||lankylad (lankylad@.discussions.microsoft.com) writes:
> All the advice from Microsoft seems to be to avoid mixed authentication,
> so I have been trying to use only Windows Authentication.
I was involved in a thread recently, where people with more experience than
me of ASP .Net appeared to say that SQL Authentication is the way to. See
65" target="_blank">http://groups.google.com/group/micr...48400
65
SQL authentication on SQL 2000 has a couple of problems. The password is
passed only lightly masked, and there is no protection against brute force
attacks. SQL 2005 on Win 2003 is better protected against the latter.
But you should not expose SQL Server on the Internet if possible.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advanceGreg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:

> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>
>|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/d.../>
up_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...[vbcol=seagreen]
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
>|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager.
I
only installed EM from the SQL 2000 CD so that I can access the MSDE instanc
e.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:

> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the defau
lt
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/d...
etup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>
>|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...[vbcol=seagreen]
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
>|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:

> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machin
e
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
>
>|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
[vbcol=seagreen]
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:
>

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advance
Greg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance
|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:

> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>
>
|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/de...setup_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...[vbcol=seagreen]
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager. I
only installed EM from the SQL 2000 CD so that I can access the MSDE instance.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:

> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the default
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/de...setup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>
>
|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...[vbcol=seagreen]
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:

> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machine
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
>
>
|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
[vbcol=seagreen]
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advanceGreg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:
> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >I have a MSDE instance running on a server. I am able to start the services
> > for the
> > engine. But when I try to access the instance through "SQL Enterprise
> > Manager" I
> > get an error message.
> >
> > "[server name] - SQL Server does not exist or access is denied."
> >
> > I tried to access the instance through "Windows Authentication" and "SQL
> > Server Login" and I get the same error message.
> >
> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> > start
> > the SQL services and I can restore a few databases from backup to the
> > instance.
> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> > password
> > using the SAPWD switch.
> >
> >
> > Questions:
> > Is there somthing that I am forgetting to do?
> > How can I access the instance through SQL Enterprise Manager?
> >
> > Thanks in advance
>
>|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
>> Greg,
>> Instance? Have you tried servername\instancename?
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >I have a MSDE instance running on a server. I am able to start the
>> >services
>> > for the
>> > engine. But when I try to access the instance through "SQL Enterprise
>> > Manager" I
>> > get an error message.
>> >
>> > "[server name] - SQL Server does not exist or access is denied."
>> >
>> > I tried to access the instance through "Windows Authentication" and
>> > "SQL
>> > Server Login" and I get the same error message.
>> >
>> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
>> > start
>> > the SQL services and I can restore a few databases from backup to the
>> > instance.
>> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
>> > password
>> > using the SAPWD switch.
>> >
>> >
>> > Questions:
>> > Is there somthing that I am forgetting to do?
>> > How can I access the instance through SQL Enterprise Manager?
>> >
>> > Thanks in advance
>>|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager. I
only installed EM from the SQL 2000 CD so that I can access the MSDE instance.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:
> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the default
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > What do you mean servername\instancename?
> > There is no place to enter that info in SQL Enterprise Manager.
> >
> > Is there anywhere else I can enter that info?
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> Instance? Have you tried servername\instancename?
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >I have a MSDE instance running on a server. I am able to start the
> >> >services
> >> > for the
> >> > engine. But when I try to access the instance through "SQL Enterprise
> >> > Manager" I
> >> > get an error message.
> >> >
> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >
> >> > I tried to access the instance through "Windows Authentication" and
> >> > "SQL
> >> > Server Login" and I get the same error message.
> >> >
> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> >> > start
> >> > the SQL services and I can restore a few databases from backup to the
> >> > instance.
> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> >> > password
> >> > using the SAPWD switch.
> >> >
> >> >
> >> > Questions:
> >> > Is there somthing that I am forgetting to do?
> >> > How can I access the instance through SQL Enterprise Manager?
> >> >
> >> > Thanks in advance
> >>
> >>
> >>
>
>|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
>> Greg,
>> I don't use MSDE but if EM sees it as another SQL Server and not the
>> default
>> install then it probably sees it as a named instance. When you're
>> registering MSDE. For more information on named instances see:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>> > What do you mean servername\instancename?
>> > There is no place to enter that info in SQL Enterprise Manager.
>> >
>> > Is there anywhere else I can enter that info?
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> Greg,
>> >>
>> >> Instance? Have you tried servername\instancename?
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "Greg" <gregkh@.hotmail.com> wrote in message
>> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >> >I have a MSDE instance running on a server. I am able to start the
>> >> >services
>> >> > for the
>> >> > engine. But when I try to access the instance through "SQL
>> >> > Enterprise
>> >> > Manager" I
>> >> > get an error message.
>> >> >
>> >> > "[server name] - SQL Server does not exist or access is denied."
>> >> >
>> >> > I tried to access the instance through "Windows Authentication" and
>> >> > "SQL
>> >> > Server Login" and I get the same error message.
>> >> >
>> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
>> >> > to
>> >> > start
>> >> > the SQL services and I can restore a few databases from backup to
>> >> > the
>> >> > instance.
>> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
>> >> > sa
>> >> > password
>> >> > using the SAPWD switch.
>> >> >
>> >> >
>> >> > Questions:
>> >> > Is there somthing that I am forgetting to do?
>> >> > How can I access the instance through SQL Enterprise Manager?
>> >> >
>> >> > Thanks in advance
>> >>
>> >>
>> >>
>>|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:
> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machine
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > an
> > MSDE instance. I need to access thaat instance from SQL Enterprise
> > Manager. I
> > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > instance.
> >
> > How about this, How do I put the MSDE instance in single-user mode?
> >
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> I don't use MSDE but if EM sees it as another SQL Server and not the
> >> default
> >> install then it probably sees it as a named instance. When you're
> >> registering MSDE. For more information on named instances see:
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> >> > What do you mean servername\instancename?
> >> > There is no place to enter that info in SQL Enterprise Manager.
> >> >
> >> > Is there anywhere else I can enter that info?
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> Greg,
> >> >>
> >> >> Instance? Have you tried servername\instancename?
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >> >I have a MSDE instance running on a server. I am able to start the
> >> >> >services
> >> >> > for the
> >> >> > engine. But when I try to access the instance through "SQL
> >> >> > Enterprise
> >> >> > Manager" I
> >> >> > get an error message.
> >> >> >
> >> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >> >
> >> >> > I tried to access the instance through "Windows Authentication" and
> >> >> > "SQL
> >> >> > Server Login" and I get the same error message.
> >> >> >
> >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> >> >> > to
> >> >> > start
> >> >> > the SQL services and I can restore a few databases from backup to
> >> >> > the
> >> >> > instance.
> >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> >> >> > sa
> >> >> > password
> >> >> > using the SAPWD switch.
> >> >> >
> >> >> >
> >> >> > Questions:
> >> >> > Is there somthing that I am forgetting to do?
> >> >> > How can I access the instance through SQL Enterprise Manager?
> >> >> >
> >> >> > Thanks in advance
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:
> > Greg,
> >
> > So MSDE is the only SQL Server installed? Try registering with the machine
> > IP address. Or if that doesn't work try:
> >
> > (local)
> >
> > HTH
> >
> > Jerry
> >
> >
> > "Greg" <gregkh@.hotmail.com> wrote in message
> > news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > > an
> > > MSDE instance. I need to access thaat instance from SQL Enterprise
> > > Manager. I
> > > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > > instance.
> > >
> > > How about this, How do I put the MSDE instance in single-user mode?
> > >
> > >
> > > "Jerry Spivey" wrote:
> > >
> > >> Greg,
> > >>
> > >> I don't use MSDE but if EM sees it as another SQL Server and not the
> > >> default
> > >> install then it probably sees it as a named instance. When you're
> > >> registering MSDE. For more information on named instances see:
> > >>
> > >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> > >>
> > >> HTH
> > >>
> > >> Jerry
> > >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > >> > What do you mean servername\instancename?
> > >> > There is no place to enter that info in SQL Enterprise Manager.
> > >> >
> > >> > Is there anywhere else I can enter that info?
> > >> >
> > >> > "Jerry Spivey" wrote:
> > >> >
> > >> >> Greg,
> > >> >>
> > >> >> Instance? Have you tried servername\instancename?
> > >> >>
> > >> >> HTH
> > >> >>
> > >> >> Jerry
> > >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> > >> >> >I have a MSDE instance running on a server. I am able to start the
> > >> >> >services
> > >> >> > for the
> > >> >> > engine. But when I try to access the instance through "SQL
> > >> >> > Enterprise
> > >> >> > Manager" I
> > >> >> > get an error message.
> > >> >> >
> > >> >> > "[server name] - SQL Server does not exist or access is denied."
> > >> >> >
> > >> >> > I tried to access the instance through "Windows Authentication" and
> > >> >> > "SQL
> > >> >> > Server Login" and I get the same error message.
> > >> >> >
> > >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> > >> >> > to
> > >> >> > start
> > >> >> > the SQL services and I can restore a few databases from backup to
> > >> >> > the
> > >> >> > instance.
> > >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> > >> >> > sa
> > >> >> > password
> > >> >> > using the SAPWD switch.
> > >> >> >
> > >> >> >
> > >> >> > Questions:
> > >> >> > Is there somthing that I am forgetting to do?
> > >> >> > How can I access the instance through SQL Enterprise Manager?
> > >> >> >
> > >> >> > Thanks in advance
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >

Access returns blank results on localhost

I am running a sql query against a access database and when I run it under localhost or from a access query it does not return any records However if I run the same query using something like table editor or run the same query with the same page on the server it returns a full recordset.

Here is the query if that might help:

SELECT * FROM Rings WHERE Date Like '" & mid(Date,1,Instr(Date, "/")-1) & "%" & mid(Date,InstrRev(Date, "/")+1) & "' and Display = True ORDER BY Date Desc, ID Desc

Any help is greatly appreciated.
Thanks
-ScottDifferent dates?

-PatP|||I am trying to select all records from the current month from the db. Basically a new uploads list for users that will select all records for the current month and year but as I said does not return anything when run locally.

When the query runs it looks something like this:

SELECT * FROM Rings WHERE Date Like '11%2004' and Display = True ORDER BY Date Desc, ID Desc

Access Reports using IP Address

I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
Raj
In reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>
|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for
>