Properly connecting to multiple instancesof SQL servers

Hello.
I did some changes to my server and now having trouble with connections.
Took off SQL 2000 and replaced it with SQL2005 Standard.
Got one web site with the following connection via ASP:
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Data Source=(local);Provider=SQLOLEDB.1;Initial
Catalog=Motorhome;UID=xxxxxxxx;Password=xxxxxx"
%>
This produces "Login Failed" and kept doing it no matter what I have changed
in SQL 2005.
After trying to connect with numerous failing trys, I put SQL 2000 back on.
I gave it the new instance name of SQL2000.
I tried the above, and also chaned it to the follow connections:
(GLOBAL-7XQWMEEO\SQL2000)
&
(SQL2000)
These two produced the error - "Server does not exist or access denied" and
'local' still produces "login failed."
What is the correct method?
Thanks,
GB
It appears that your SQL Server was configured for Windows authentication
only. That's the default. Use the Surface Area Configuration app to change
the authentication to Mixed.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"GeekBoy" <allGeek@.hownerdy.com> wrote in message
news:46b8ffe0$0$31256$4c368faf@.roadrunner.com...
Hello.
I did some changes to my server and now having trouble with connections.
Took off SQL 2000 and replaced it with SQL2005 Standard.
Got one web site with the following connection via ASP:
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Data Source=(local);Provider=SQLOLEDB.1;Initial
Catalog=Motorhome;UID=xxxxxxxx;Password=xxxxxx"
%>
This produces "Login Failed" and kept doing it no matter what I have changed
in SQL 2005.
After trying to connect with numerous failing trys, I put SQL 2000 back on.
I gave it the new instance name of SQL2000.
I tried the above, and also chaned it to the follow connections:
(GLOBAL-7XQWMEEO\SQL2000)
&
(SQL2000)
These two produced the error - "Server does not exist or access denied" and
'local' still produces "login failed."
What is the correct method?
Thanks,
GB
|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OJ7XmMV2HHA.1164@.TK2MSFTNGP02.phx.gbl...
> It appears that your SQL Server was configured for Windows authentication
> only. That's the default. Use the Surface Area Configuration app to
> change
> the authentication to Mixed.
>
First thing I did.

> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "GeekBoy" <allGeek@.hownerdy.com> wrote in message
> news:46b8ffe0$0$31256$4c368faf@.roadrunner.com...
> Hello.
> I did some changes to my server and now having trouble with connections.
> Took off SQL 2000 and replaced it with SQL2005 Standard.
> Got one web site with the following connection via ASP:
> <%
> Set conn = Server.CreateObject("ADODB.Connection")
> conn.Open "Data Source=(local);Provider=SQLOLEDB.1;Initial
> Catalog=Motorhome;UID=xxxxxxxx;Password=xxxxxx"
> %>
> This produces "Login Failed" and kept doing it no matter what I have
> changed
> in SQL 2005.
> After trying to connect with numerous failing trys, I put SQL 2000 back
> on.
> I gave it the new instance name of SQL2000.
> I tried the above, and also chaned it to the follow connections:
> (GLOBAL-7XQWMEEO\SQL2000)
> &
> (SQL2000)
> These two produced the error - "Server does not exist or access denied"
> and
> 'local' still produces "login failed."
> What is the correct method?
> Thanks,
> GB
>
>
|||How about with the SQL client tools? Just want to be sure it isn't the
OLEDB stuff.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"GeekBoy" <allGeek@.hownerdy.com> wrote in message
news:46b919a4$0$4680$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OJ7XmMV2HHA.1164@.TK2MSFTNGP02.phx.gbl...
> It appears that your SQL Server was configured for Windows authentication
> only. That's the default. Use the Surface Area Configuration app to
> change
> the authentication to Mixed.
>
First thing I did.

> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "GeekBoy" <allGeek@.hownerdy.com> wrote in message
> news:46b8ffe0$0$31256$4c368faf@.roadrunner.com...
> Hello.
> I did some changes to my server and now having trouble with connections.
> Took off SQL 2000 and replaced it with SQL2005 Standard.
> Got one web site with the following connection via ASP:
> <%
> Set conn = Server.CreateObject("ADODB.Connection")
> conn.Open "Data Source=(local);Provider=SQLOLEDB.1;Initial
> Catalog=Motorhome;UID=xxxxxxxx;Password=xxxxxx"
> %>
> This produces "Login Failed" and kept doing it no matter what I have
> changed
> in SQL 2005.
> After trying to connect with numerous failing trys, I put SQL 2000 back
> on.
> I gave it the new instance name of SQL2000.
> I tried the above, and also chaned it to the follow connections:
> (GLOBAL-7XQWMEEO\SQL2000)
> &
> (SQL2000)
> These two produced the error - "Server does not exist or access denied"
> and
> 'local' still produces "login failed."
> What is the correct method?
> Thanks,
> GB
>
>
|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:e0cIpqV2HHA.748@.TK2MSFTNGP04.phx.gbl...
> How about with the SQL client tools? Just want to be sure it isn't the
> OLEDB stuff.
>
Yes, I check under both 2000/2005.
Both seem to be set correctly.
I even tried to make user Windows user acount instead of using the SQL
login.

> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "GeekBoy" <allGeek@.hownerdy.com> wrote in message
> news:46b919a4$0$4680$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OJ7XmMV2HHA.1164@.TK2MSFTNGP02.phx.gbl...
> First thing I did.
>
>
|||Try this...
"Provider=SQLOleDb; Data Source =(local); Database=Motorhome;
Trusted_Connection=yes;UID=xxxxxxxx;Password=xxxxx x"
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"GeekBoy" wrote:

> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:e0cIpqV2HHA.748@.TK2MSFTNGP04.phx.gbl...
> Yes, I check under both 2000/2005.
> Both seem to be set correctly.
> I even tried to make user Windows user acount instead of using the SQL
> login.
>
>
>
|||"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:2EB663D4-30BB-4353-B61E-EE574D883ED3@.microsoft.com...
> Try this...
> "Provider=SQLOleDb; Data Source =(local); Database=Motorhome;
> Trusted_Connection=yes;UID=xxxxxxxx;Password=xxxxx x"
Still not functioning,
I still need to know how to properly label the instance of "SQL2000," while
'local' is pointing to SQL 2005.
Though I did try to run another copy of the database in SQL 2005, still
getting same response.
Thanks

>
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and
> time
> asking back if its 2000 or 2005]
>
[vbcol=seagreen]
> "GeekBoy" wrote:
|||From a command prompt, could you run:
NET START
... and post the parts that mention SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"GeekBoy" <allGeek@.hownerdy.com> wrote in message
news:46b921f0$0$8926$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:e0cIpqV2HHA.748@.TK2MSFTNGP04.phx.gbl...
> How about with the SQL client tools? Just want to be sure it isn't the
> OLEDB stuff.
>
Yes, I check under both 2000/2005.
Both seem to be set correctly.
I even tried to make user Windows user acount instead of using the SQL
login.

> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "GeekBoy" <allGeek@.hownerdy.com> wrote in message
> news:46b919a4$0$4680$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OJ7XmMV2HHA.1164@.TK2MSFTNGP02.phx.gbl...
> First thing I did.
>
>
|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OdHSGng2HHA.3764@.TK2MSFTNGP04.phx.gbl...
> From a command prompt, could you run:
> NET START
> ... and post the parts that mention SQL Server.
Here is is:
SQL Server (MSSQLSERVER)
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Browser
SQL Server FullText Search (MSSQLSERVER)
SQL Server Integration Services
SQL Server Reporting Services (MSSQLSERVER)

> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "GeekBoy" <allGeek@.hownerdy.com> wrote in message
> news:46b921f0$0$8926$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:e0cIpqV2HHA.748@.TK2MSFTNGP04.phx.gbl...
> Yes, I check under both 2000/2005.
> Both seem to be set correctly.
> I even tried to make user Windows user acount instead of using the SQL
> login.
>
>
>
|||OK, that means that you are using a default instance. When you connect via
SSMS, while logged on directly at the box, what do you type into the Server
box? Have you tried just typing a dot:
..
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"GeekBoy" <nobody@.spamcop.net> wrote in message
news:46ba482f$0$3159$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OdHSGng2HHA.3764@.TK2MSFTNGP04.phx.gbl...
> From a command prompt, could you run:
> NET START
> ... and post the parts that mention SQL Server.
Here is is:
SQL Server (MSSQLSERVER)
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Browser
SQL Server FullText Search (MSSQLSERVER)
SQL Server Integration Services
SQL Server Reporting Services (MSSQLSERVER)

> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "GeekBoy" <allGeek@.hownerdy.com> wrote in message
> news:46b921f0$0$8926$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:e0cIpqV2HHA.748@.TK2MSFTNGP04.phx.gbl...
> Yes, I check under both 2000/2005.
> Both seem to be set correctly.
> I even tried to make user Windows user acount instead of using the SQL
> login.
>
>
>