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,
GBIt 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...
>> 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
>>
>|||Try this...
"Provider=SQLOleDb; Data Source =(local); Database=Motorhome;
Trusted_Connection=yes;UID=xxxxxxxx;Password=xxxxxx"
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...
> > 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...
> >> 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
> >>
> >>
> >>
> >
> >
>
>|||"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=xxxxxx"
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]
>
> "GeekBoy" wrote:
>> "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...
>> >> 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
>> >>
>> >>
>> >>
>> >
>> >
>>|||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...
>> 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: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...
>> 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...
>> 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
>>
>>
>|||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...
>> 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...
>> 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:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
> 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:
>
I don't type in anything. The boxes are already filled in and logg in using
a user account that has admin privleges.
never mind. Gosh how stupid.
The SQL2000 instance was not running in the services.
However, it still does not explain why I could not use 2005 to log in with
the the first error I received.
> .
> --
> 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...
>> 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...
>> 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
>>
>>
>>
>|||OK, I'm a bit lost now. You can connect now, right? You have only one
instance on the box now and it's SQL 2000, right? You're just asking what
the problem was when logging into a SQL 2005 instance with SSMS? I guess
since the instance is gone, we won't be able to troubleshoot that one.
--
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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
> 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:
>
I don't type in anything. The boxes are already filled in and logg in using
a user account that has admin privleges.
never mind. Gosh how stupid.
The SQL2000 instance was not running in the services.
However, it still does not explain why I could not use 2005 to log in with
the the first error I received.
> .
> --
> 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...
>> 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...
>> 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:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> OK, I'm a bit lost now. You can connect now, right? You have only one
> instance on the box now and it's SQL 2000, right? You're just asking what
> the problem was when logging into a SQL 2005 instance with SSMS? I guess
> since the instance is gone, we won't be able to troubleshoot that one.
I have 2 instances running.
The SQL2000 one was not running because in the services it was set to manual
start.
So now I have both of them running.
I have not had any problem with SSMS, it was with ASP logging in using an
SQL account.
Strange thing is I set up the database up using SSMS on version 9 (2005) SQL
server.
So now I don't know what is going on.
> --
> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
> I don't type in anything. The boxes are already filled in and logg in
> using
> a user account that has admin privleges.
> never mind. Gosh how stupid.
> The SQL2000 instance was not running in the services.
> However, it still does not explain why I could not use 2005 to log in with
> the the first error I received.
>> .
>> --
>> 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...
>> 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...
>> 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
>>
>>
>>
>>
>|||Was ASP running on the same box or a different one?
--
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:46ba688f$0$12176$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> OK, I'm a bit lost now. You can connect now, right? You have only one
> instance on the box now and it's SQL 2000, right? You're just asking what
> the problem was when logging into a SQL 2005 instance with SSMS? I guess
> since the instance is gone, we won't be able to troubleshoot that one.
I have 2 instances running.
The SQL2000 one was not running because in the services it was set to manual
start.
So now I have both of them running.
I have not had any problem with SSMS, it was with ASP logging in using an
SQL account.
Strange thing is I set up the database up using SSMS on version 9 (2005) SQL
server.
So now I don't know what is going on.
> --
> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
> I don't type in anything. The boxes are already filled in and logg in
> using
> a user account that has admin privleges.
> never mind. Gosh how stupid.
> The SQL2000 instance was not running in the services.
> However, it still does not explain why I could not use 2005 to log in with
> the the first error I received.
>> .
>> --
>> 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...
>> 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...
>> 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:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> Was ASP running on the same box or a different one?
Same one.
> --
> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I guess
>> since the instance is gone, we won't be able to troubleshoot that one.
> I have 2 instances running.
> The SQL2000 one was not running because in the services it was set to
> manual
> start.
> So now I have both of them running.
> I have not had any problem with SSMS, it was with ASP logging in using an
> SQL account.
> Strange thing is I set up the database up using SSMS on version 9 (2005)
> SQL
> server.
> So now I don't know what is going on.
>
>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>> 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...
>> 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
>>
>>
>>
>>
>>
>|||Dunno what to say. Can't troubleshoot without it being there. I guess you
could always add a 2005 instance and see if you can repro it.
--
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" <geek@.boy.com> wrote in message
news:46ba775e$0$28682$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> Was ASP running on the same box or a different one?
Same one.
> --
> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I guess
>> since the instance is gone, we won't be able to troubleshoot that one.
> I have 2 instances running.
> The SQL2000 one was not running because in the services it was set to
> manual
> start.
> So now I have both of them running.
> I have not had any problem with SSMS, it was with ASP logging in using an
> SQL account.
> Strange thing is I set up the database up using SSMS on version 9 (2005)
> SQL
> server.
> So now I don't know what is going on.
>
>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>> 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...
>> 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:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
> Dunno what to say. Can't troubleshoot without it being there. I guess
> you
> could always add a 2005 instance and see if you can repro it.
>
The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
> --
> 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" <geek@.boy.com> wrote in message
> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>
> Same one.
>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9 (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>> 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...
>>> 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
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Now I'm more confused. How many instances are on the box? If it's more
than one, which SQL Servers are they and what are the instance names?
--
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" <geek@.boy.com> wrote in message
news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
> Dunno what to say. Can't troubleshoot without it being there. I guess
> you
> could always add a 2005 instance and see if you can repro it.
>
The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
> --
> 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" <geek@.boy.com> wrote in message
> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>
> Same one.
>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9 (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>> 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...
>>> 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
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
> Now I'm more confused. How many instances are on the box? If it's more
> than one, which SQL Servers are they and what are the instance names?
> --
> 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" <geek@.boy.com> wrote in message
> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>
> The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9 (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>>> 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...
>>> 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
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||Which is the default instance and which is the named instance?
--
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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
> Now I'm more confused. How many instances are on the box? If it's more
> than one, which SQL Servers are they and what are the instance names?
> --
> 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" <geek@.boy.com> wrote in message
> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>
> The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9 (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>>> 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...
>>> 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
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||2005 is default while "SQL2000" is the named.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
> Which is the default instance and which is the named instance?
> --
> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only
>> one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9
>> (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>>> 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...
>>> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||OK, so you can connect to both of the following:
.
.\SQL2000
Correct?
--
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:46bb7068$0$30668$4c368faf@.roadrunner.com...
2005 is default while "SQL2000" is the named.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
> Which is the default instance and which is the named instance?
> --
> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only
>> one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9
>> (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>> 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:
>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>> .
>> --
>> 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...
>>> 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...
>>> 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:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
> OK, so you can connect to both of the following:
> .
> .\SQL2000
> Correct?
>
I am familair with mySQL, but not MS SQL, so I do not know about the
reference you make concerning the way you are showing to connect.
> --
> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
> 2005 is default while "SQL2000" is the named.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only
>> one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that
>> one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9
>> (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>> 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:
>>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>>> .
>>>
>>> --
>>> 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...
>>> 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...
>>>> 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
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||When you use SSMS to connect to each of those instances while logged on
locally, what do you type into the Server text box? For the default (2005)
instance, it should be a dot. For the SQL 2000 instance, it should be
.\SQL2000. Have you tried that?
--
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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
> OK, so you can connect to both of the following:
> .
> .\SQL2000
> Correct?
>
I am familair with mySQL, but not MS SQL, so I do not know about the
reference you make concerning the way you are showing to connect.
> --
> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
> 2005 is default while "SQL2000" is the named.
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> OK, I'm a bit lost now. You can connect now, right? You have only
>> one
>> instance on the box now and it's SQL 2000, right? You're just asking
>> what
>> the problem was when logging into a SQL 2005 instance with SSMS? I
>> guess
>> since the instance is gone, we won't be able to troubleshoot that
>> one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9
>> (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>
>> --
>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>> 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:
>>>
>> I don't type in anything. The boxes are already filled in and logg in
>> using
>> a user account that has admin privleges.
>> never mind. Gosh how stupid.
>> The SQL2000 instance was not running in the services.
>> However, it still does not explain why I could not use 2005 to log in
>> with
>> the the first error I received.
>>> .
>>>
>>> --
>>> 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...
>>> 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...
>>>> 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:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
> When you use SSMS to connect to each of those instances while logged on
> locally, what do you type into the Server text box? For the default
> (2005)
> instance, it should be a dot. For the SQL 2000 instance, it should be
> .\SQL2000. Have you tried that?
>
I type in nothing. All the fields are already filled in.
Server Type: Database Engine
Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
Authentication: "my login user name"
> --
> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>
> I am familair with mySQL, but not MS SQL, so I do not know about the
> reference you make concerning the way you are showing to connect.
>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's
>> more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I
>> guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>> instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> OK, I'm a bit lost now. You can connect now, right? You have only
>>> one
>>> instance on the box now and it's SQL 2000, right? You're just
>>> asking
>>> what
>>> the problem was when logging into a SQL 2005 instance with SSMS? I
>>> guess
>>> since the instance is gone, we won't be able to troubleshoot that
>>> one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in
>> using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9
>> (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>>
>>> --
>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>> 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:
>>>
>>>
>>> I don't type in anything. The boxes are already filled in and logg
>>> in
>>> using
>>> a user account that has admin privleges.
>>>
>>> never mind. Gosh how stupid.
>>> The SQL2000 instance was not running in the services.
>>>
>>> However, it still does not explain why I could not use 2005 to log
>>> in
>>> with
>>> the the first error I received.
>>>
>>> .
>>>
>>> --
>>> 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...
>>>> 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...
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||The second one should use a backslash, not a forward slash:
GLOBAL-7XQWMEEO\SQL2000
--
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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
> When you use SSMS to connect to each of those instances while logged on
> locally, what do you type into the Server text box? For the default
> (2005)
> instance, it should be a dot. For the SQL 2000 instance, it should be
> .\SQL2000. Have you tried that?
>
I type in nothing. All the fields are already filled in.
Server Type: Database Engine
Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
Authentication: "my login user name"
> --
> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>
> I am familair with mySQL, but not MS SQL, so I do not know about the
> reference you make concerning the way you are showing to connect.
>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's
>> more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I
>> guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>> instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>> --
>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> OK, I'm a bit lost now. You can connect now, right? You have only
>>> one
>>> instance on the box now and it's SQL 2000, right? You're just
>>> asking
>>> what
>>> the problem was when logging into a SQL 2005 instance with SSMS? I
>>> guess
>>> since the instance is gone, we won't be able to troubleshoot that
>>> one.
>> I have 2 instances running.
>> The SQL2000 one was not running because in the services it was set to
>> manual
>> start.
>> So now I have both of them running.
>> I have not had any problem with SSMS, it was with ASP logging in
>> using
>> an
>> SQL account.
>> Strange thing is I set up the database up using SSMS on version 9
>> (2005)
>> SQL
>> server.
>> So now I don't know what is going on.
>>
>>
>>>
>>> --
>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>> 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:
>>>
>>>
>>> I don't type in anything. The boxes are already filled in and logg
>>> in
>>> using
>>> a user account that has admin privleges.
>>>
>>> never mind. Gosh how stupid.
>>> The SQL2000 instance was not running in the services.
>>>
>>> However, it still does not explain why I could not use 2005 to log
>>> in
>>> with
>>> the the first error I received.
>>>
>>> .
>>>
>>> --
>>> 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...
>>>> 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...
>>>> 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:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
> The second one should use a backslash, not a forward slash:
> GLOBAL-7XQWMEEO\SQL2000
>
I did not put that in there, the system does and it works fine.
> --
> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>
> I type in nothing. All the fields are already filled in.
> Server Type: Database Engine
> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
> Authentication: "my login user name"
>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's
>> more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I
>> guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>> instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>>>
>>> --
>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> OK, I'm a bit lost now. You can connect now, right? You have only
>>> one
>>> instance on the box now and it's SQL 2000, right? You're just
>>> asking
>>> what
>>> the problem was when logging into a SQL 2005 instance with SSMS? I
>>> guess
>>> since the instance is gone, we won't be able to troubleshoot that
>>> one.
>>>
>>> I have 2 instances running.
>>> The SQL2000 one was not running because in the services it was set
>>> to
>>> manual
>>> start.
>>> So now I have both of them running.
>>>
>>> I have not had any problem with SSMS, it was with ASP logging in
>>> using
>>> an
>>> SQL account.
>>>
>>> Strange thing is I set up the database up using SSMS on version 9
>>> (2005)
>>> SQL
>>> server.
>>>
>>> So now I don't know what is going on.
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>> 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:
>>>
>>>
>>> I don't type in anything. The boxes are already filled in and logg
>>> in
>>> using
>>> a user account that has admin privleges.
>>>
>>> never mind. Gosh how stupid.
>>> The SQL2000 instance was not running in the services.
>>>
>>> However, it still does not explain why I could not use 2005 to log
>>> in
>>> with
>>> the the first error I received.
>>>
>>> .
>>>
>>> --
>>> 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...
>>>> 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...
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||So I take it that there is no longer a problem?
--
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:46bb8b06$0$29656$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
> The second one should use a backslash, not a forward slash:
> GLOBAL-7XQWMEEO\SQL2000
>
I did not put that in there, the system does and it works fine.
> --
> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>
> I type in nothing. All the fields are already filled in.
> Server Type: Database Engine
> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
> Authentication: "my login user name"
>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's
>> more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>> Dunno what to say. Can't troubleshoot without it being there. I
>> guess
>> you
>> could always add a 2005 instance and see if you can repro it.
>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>> instance.
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> Was ASP running on the same box or a different one?
>>
>> Same one.
>>
>>>
>>> --
>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> OK, I'm a bit lost now. You can connect now, right? You have only
>>> one
>>> instance on the box now and it's SQL 2000, right? You're just
>>> asking
>>> what
>>> the problem was when logging into a SQL 2005 instance with SSMS? I
>>> guess
>>> since the instance is gone, we won't be able to troubleshoot that
>>> one.
>>>
>>> I have 2 instances running.
>>> The SQL2000 one was not running because in the services it was set
>>> to
>>> manual
>>> start.
>>> So now I have both of them running.
>>>
>>> I have not had any problem with SSMS, it was with ASP logging in
>>> using
>>> an
>>> SQL account.
>>>
>>> Strange thing is I set up the database up using SSMS on version 9
>>> (2005)
>>> SQL
>>> server.
>>>
>>> So now I don't know what is going on.
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>> 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:
>>>
>>>
>>> I don't type in anything. The boxes are already filled in and logg
>>> in
>>> using
>>> a user account that has admin privleges.
>>>
>>> never mind. Gosh how stupid.
>>> The SQL2000 instance was not running in the services.
>>>
>>> However, it still does not explain why I could not use 2005 to log
>>> in
>>> with
>>> the the first error I received.
>>>
>>> .
>>>
>>> --
>>> 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...
>>>> 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...
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||Not since I started the SQL2000 instance in the server in "services."
Hence Why I ask why the databse is functioning now, when the SQL2000
instance was not running, but the database is setup in the SQL 2005
instance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O6IL4Bt2HHA.4880@.TK2MSFTNGP03.phx.gbl...
> So I take it that there is no longer a problem?
> --
> 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:46bb8b06$0$29656$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
>> The second one should use a backslash, not a forward slash:
>> GLOBAL-7XQWMEEO\SQL2000
> I did not put that in there, the system does and it works fine.
>
>> --
>> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>>
>>
>> I type in nothing. All the fields are already filled in.
>> Server Type: Database Engine
>> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
>> Authentication: "my login user name"
>>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's
>> more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>>> Dunno what to say. Can't troubleshoot without it being there. I
>>> guess
>>> you
>>> could always add a 2005 instance and see if you can repro it.
>>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>> instance.
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> Was ASP running on the same box or a different one?
>>>
>>>
>>> Same one.
>>>
>>>
>>>
>>> --
>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> OK, I'm a bit lost now. You can connect now, right? You have
>>> only
>>> one
>>> instance on the box now and it's SQL 2000, right? You're just
>>> asking
>>> what
>>> the problem was when logging into a SQL 2005 instance with SSMS?
>>> I
>>> guess
>>> since the instance is gone, we won't be able to troubleshoot that
>>> one.
>>>
>>> I have 2 instances running.
>>> The SQL2000 one was not running because in the services it was set
>>> to
>>> manual
>>> start.
>>> So now I have both of them running.
>>>
>>> I have not had any problem with SSMS, it was with ASP logging in
>>> using
>>> an
>>> SQL account.
>>>
>>> Strange thing is I set up the database up using SSMS on version 9
>>> (2005)
>>> SQL
>>> server.
>>>
>>> So now I don't know what is going on.
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>>> 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:
>>>>
>>>
>>> I don't type in anything. The boxes are already filled in and logg
>>> in
>>> using
>>> a user account that has admin privleges.
>>>
>>> never mind. Gosh how stupid.
>>> The SQL2000 instance was not running in the services.
>>>
>>> However, it still does not explain why I could not use 2005 to log
>>> in
>>> with
>>> the the first error I received.
>>>
>>>> .
>>>>
>>>> --
>>>> 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...
>>>> 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...
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>|||I'm confused again. You say that the DB is functioning "when the SQL2000
instance was not running". That's not really possible.
--
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:46bb929f$0$4684$4c368faf@.roadrunner.com...
Not since I started the SQL2000 instance in the server in "services."
Hence Why I ask why the databse is functioning now, when the SQL2000
instance was not running, but the database is setup in the SQL 2005
instance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O6IL4Bt2HHA.4880@.TK2MSFTNGP03.phx.gbl...
> So I take it that there is no longer a problem?
> --
> 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:46bb8b06$0$29656$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
>> The second one should use a backslash, not a forward slash:
>> GLOBAL-7XQWMEEO\SQL2000
> I did not put that in there, the system does and it works fine.
>
>> --
>> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>>
>>
>> I type in nothing. All the fields are already filled in.
>> Server Type: Database Engine
>> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
>> Authentication: "my login user name"
>>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Now I'm more confused. How many instances are on the box? If it's
>> more
>> than one, which SQL Servers are they and what are the instance names?
>> --
>> 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" <geek@.boy.com> wrote in message
>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>>> Dunno what to say. Can't troubleshoot without it being there. I
>>> guess
>>> you
>>> could always add a 2005 instance and see if you can repro it.
>>>
>>
>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>> instance.
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> Was ASP running on the same box or a different one?
>>>
>>>
>>> Same one.
>>>
>>>
>>>
>>> --
>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> OK, I'm a bit lost now. You can connect now, right? You have
>>> only
>>> one
>>> instance on the box now and it's SQL 2000, right? You're just
>>> asking
>>> what
>>> the problem was when logging into a SQL 2005 instance with SSMS?
>>> I
>>> guess
>>> since the instance is gone, we won't be able to troubleshoot that
>>> one.
>>>
>>> I have 2 instances running.
>>> The SQL2000 one was not running because in the services it was set
>>> to
>>> manual
>>> start.
>>> So now I have both of them running.
>>>
>>> I have not had any problem with SSMS, it was with ASP logging in
>>> using
>>> an
>>> SQL account.
>>>
>>> Strange thing is I set up the database up using SSMS on version 9
>>> (2005)
>>> SQL
>>> server.
>>>
>>> So now I don't know what is going on.
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>>> 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:
>>>>
>>>
>>> I don't type in anything. The boxes are already filled in and logg
>>> in
>>> using
>>> a user account that has admin privleges.
>>>
>>> never mind. Gosh how stupid.
>>> The SQL2000 instance was not running in the services.
>>>
>>> However, it still does not explain why I could not use 2005 to log
>>> in
>>> with
>>> the the first error I received.
>>>
>>>> .
>>>>
>>>> --
>>>> 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...
>>>> 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...
>>>> 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:%23p3emHu2HHA.484@.TK2MSFTNGP06.phx.gbl...
> I'm confused again. You say that the DB is functioning "when the SQL2000
> instance was not running". That's not really possible.
>
No..you have that switched around.
> --
> 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:46bb929f$0$4684$4c368faf@.roadrunner.com...
> Not since I started the SQL2000 instance in the server in "services."
> Hence Why I ask why the databse is functioning now, when the SQL2000
> instance was not running, but the database is setup in the SQL 2005
> instance.
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:O6IL4Bt2HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> So I take it that there is no longer a problem?
>> --
>> 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:46bb8b06$0$29656$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
>> The second one should use a backslash, not a forward slash:
>> GLOBAL-7XQWMEEO\SQL2000
>>
>> I did not put that in there, the system does and it works fine.
>>
>> --
>> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>>
>>
>> I type in nothing. All the fields are already filled in.
>> Server Type: Database Engine
>> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
>> Authentication: "my login user name"
>>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>>> Now I'm more confused. How many instances are on the box? If it's
>>> more
>>> than one, which SQL Servers are they and what are the instance
>>> names?
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>>> Dunno what to say. Can't troubleshoot without it being there. I
>>> guess
>>> you
>>> could always add a 2005 instance and see if you can repro it.
>>>
>>>
>>>
>>>
>>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>>> instance.
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> Was ASP running on the same box or a different one?
>>>
>>>
>>> Same one.
>>>
>>>
>>>
>>> --
>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>>> OK, I'm a bit lost now. You can connect now, right? You have
>>>> only
>>>> one
>>>> instance on the box now and it's SQL 2000, right? You're just
>>>> asking
>>>> what
>>>> the problem was when logging into a SQL 2005 instance with SSMS?
>>>> I
>>>> guess
>>>> since the instance is gone, we won't be able to troubleshoot that
>>>> one.
>>>
>>> I have 2 instances running.
>>> The SQL2000 one was not running because in the services it was set
>>> to
>>> manual
>>> start.
>>> So now I have both of them running.
>>>
>>> I have not had any problem with SSMS, it was with ASP logging in
>>> using
>>> an
>>> SQL account.
>>>
>>> Strange thing is I set up the database up using SSMS on version 9
>>> (2005)
>>> SQL
>>> server.
>>>
>>> So now I don't know what is going on.
>>>
>>>
>>>
>>>
>>>
>>>>
>>>> --
>>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>>
>>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>>> 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:
>>>>
>>>>
>>>> I don't type in anything. The boxes are already filled in and
>>>> logg
>>>> in
>>>> using
>>>> a user account that has admin privleges.
>>>>
>>>> never mind. Gosh how stupid.
>>>> The SQL2000 instance was not running in the services.
>>>>
>>>> However, it still does not explain why I could not use 2005 to
>>>> log
>>>> in
>>>> with
>>>> the the first error I received.
>>>>
>>>> .
>>>>
>>>> --
>>>> 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...
>>>> 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...
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||You've lost me now...
--
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:46bbb43a$0$4919$4c368faf@.roadrunner.com...
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23p3emHu2HHA.484@.TK2MSFTNGP06.phx.gbl...
> I'm confused again. You say that the DB is functioning "when the SQL2000
> instance was not running". That's not really possible.
>
No..you have that switched around.
> --
> 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:46bb929f$0$4684$4c368faf@.roadrunner.com...
> Not since I started the SQL2000 instance in the server in "services."
> Hence Why I ask why the databse is functioning now, when the SQL2000
> instance was not running, but the database is setup in the SQL 2005
> instance.
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:O6IL4Bt2HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> So I take it that there is no longer a problem?
>> --
>> 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:46bb8b06$0$29656$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
>> The second one should use a backslash, not a forward slash:
>> GLOBAL-7XQWMEEO\SQL2000
>>
>> I did not put that in there, the system does and it works fine.
>>
>> --
>> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>>
>>
>> I type in nothing. All the fields are already filled in.
>> Server Type: Database Engine
>> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
>> Authentication: "my login user name"
>>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>> Which is the default instance and which is the named instance?
>> --
>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>>> Now I'm more confused. How many instances are on the box? If it's
>>> more
>>> than one, which SQL Servers are they and what are the instance
>>> names?
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>>> Dunno what to say. Can't troubleshoot without it being there. I
>>> guess
>>> you
>>> could always add a 2005 instance and see if you can repro it.
>>>
>>>
>>>
>>>
>>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>>> instance.
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>> Was ASP running on the same box or a different one?
>>>
>>>
>>> Same one.
>>>
>>>
>>>
>>> --
>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>>> OK, I'm a bit lost now. You can connect now, right? You have
>>>> only
>>>> one
>>>> instance on the box now and it's SQL 2000, right? You're just
>>>> asking
>>>> what
>>>> the problem was when logging into a SQL 2005 instance with SSMS?
>>>> I
>>>> guess
>>>> since the instance is gone, we won't be able to troubleshoot that
>>>> one.
>>>
>>> I have 2 instances running.
>>> The SQL2000 one was not running because in the services it was set
>>> to
>>> manual
>>> start.
>>> So now I have both of them running.
>>>
>>> I have not had any problem with SSMS, it was with ASP logging in
>>> using
>>> an
>>> SQL account.
>>>
>>> Strange thing is I set up the database up using SSMS on version 9
>>> (2005)
>>> SQL
>>> server.
>>>
>>> So now I don't know what is going on.
>>>
>>>
>>>
>>>
>>>
>>>>
>>>> --
>>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>>
>>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>>> 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:
>>>>
>>>>
>>>> I don't type in anything. The boxes are already filled in and
>>>> logg
>>>> in
>>>> using
>>>> a user account that has admin privleges.
>>>>
>>>> never mind. Gosh how stupid.
>>>> The SQL2000 instance was not running in the services.
>>>>
>>>> However, it still does not explain why I could not use 2005 to
>>>> log
>>>> in
>>>> with
>>>> the the first error I received.
>>>>
>>>> .
>>>>
>>>> --
>>>> 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...
>>>> 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...
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||The database did not function until I started the SQL 2000 instance in the
"services."
The issue is, how can it start to function again if the SQL 2000 server was
started while it is setup to run on the SQL 2005 instance?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OeJ1rfu2HHA.1208@.TK2MSFTNGP03.phx.gbl...
> You've lost me now...
> --
> 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:46bbb43a$0$4919$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23p3emHu2HHA.484@.TK2MSFTNGP06.phx.gbl...
>> I'm confused again. You say that the DB is functioning "when the SQL2000
>> instance was not running". That's not really possible.
>
> No..you have that switched around.
>
>
>> --
>> 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:46bb929f$0$4684$4c368faf@.roadrunner.com...
>> Not since I started the SQL2000 instance in the server in "services."
>> Hence Why I ask why the databse is functioning now, when the SQL2000
>> instance was not running, but the database is setup in the SQL 2005
>> instance.
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:O6IL4Bt2HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> So I take it that there is no longer a problem?
>> --
>> 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:46bb8b06$0$29656$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
>> The second one should use a backslash, not a forward slash:
>> GLOBAL-7XQWMEEO\SQL2000
>>
>> I did not put that in there, the system does and it works fine.
>>
>> --
>> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged
>> on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>>
>>
>> I type in nothing. All the fields are already filled in.
>> Server Type: Database Engine
>> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
>> Authentication: "my login user name"
>>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>>> Which is the default instance and which is the named instance?
>>>
>>> --
>>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>>
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>>> Now I'm more confused. How many instances are on the box? If it's
>>> more
>>> than one, which SQL Servers are they and what are the instance
>>> names?
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>>> Dunno what to say. Can't troubleshoot without it being there. I
>>> guess
>>> you
>>> could always add a 2005 instance and see if you can repro it.
>>>
>>>
>>>
>>>
>>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>>> instance.
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>>> Was ASP running on the same box or a different one?
>>>
>>>
>>> Same one.
>>>
>>>
>>>>
>>>> --
>>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>>
>>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>>> OK, I'm a bit lost now. You can connect now, right? You have
>>>> only
>>>> one
>>>> instance on the box now and it's SQL 2000, right? You're just
>>>> asking
>>>> what
>>>> the problem was when logging into a SQL 2005 instance with SSMS?
>>>> I
>>>> guess
>>>> since the instance is gone, we won't be able to troubleshoot
>>>> that
>>>> one.
>>>>
>>>> I have 2 instances running.
>>>> The SQL2000 one was not running because in the services it was
>>>> set
>>>> to
>>>> manual
>>>> start.
>>>> So now I have both of them running.
>>>>
>>>> I have not had any problem with SSMS, it was with ASP logging in
>>>> using
>>>> an
>>>> SQL account.
>>>>
>>>> Strange thing is I set up the database up using SSMS on version 9
>>>> (2005)
>>>> SQL
>>>> server.
>>>>
>>>> So now I don't know what is going on.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>>
>>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>>> 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:
>>>>
>>>>
>>>> I don't type in anything. The boxes are already filled in and
>>>> logg
>>>> in
>>>> using
>>>> a user account that has admin privleges.
>>>>
>>>> never mind. Gosh how stupid.
>>>> The SQL2000 instance was not running in the services.
>>>>
>>>> However, it still does not explain why I could not use 2005 to
>>>> log
>>>> in
>>>> with
>>>> the the first error I received.
>>>>
>>>> .
>>>>
>>>> --
>>>> 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...
>>>>> 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...
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Looks like your app is pointing to the SQL 2000 instance and not the SQL
2005 instance. Perhaps you can try:
conn.Open "Data Source=.;Provider=SQLOLEDB.1;Initial
Catalog=Motorhome;UID=xxxxxxxx;Password=xxxxxx"
conn.Open "Data Source=.\SQL2000;Provider=SQLOLEDB.1;Initial
Catalog=Motorhome;UID=xxxxxxxx;Password=xxxxxx"
Do these connect? Failing that, the following link may be useful:
http://www.connectionstrings.com/
--
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:46bbbdd5$0$28669$4c368faf@.roadrunner.com...
The database did not function until I started the SQL 2000 instance in the
"services."
The issue is, how can it start to function again if the SQL 2000 server was
started while it is setup to run on the SQL 2005 instance?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OeJ1rfu2HHA.1208@.TK2MSFTNGP03.phx.gbl...
> You've lost me now...
> --
> 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:46bbb43a$0$4919$4c368faf@.roadrunner.com...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23p3emHu2HHA.484@.TK2MSFTNGP06.phx.gbl...
>> I'm confused again. You say that the DB is functioning "when the SQL2000
>> instance was not running". That's not really possible.
>
> No..you have that switched around.
>
>
>> --
>> 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:46bb929f$0$4684$4c368faf@.roadrunner.com...
>> Not since I started the SQL2000 instance in the server in "services."
>> Hence Why I ask why the databse is functioning now, when the SQL2000
>> instance was not running, but the database is setup in the SQL 2005
>> instance.
>>
>>
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:O6IL4Bt2HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> So I take it that there is no longer a problem?
>> --
>> 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:46bb8b06$0$29656$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:el2J2hs2HHA.2064@.TK2MSFTNGP03.phx.gbl...
>> The second one should use a backslash, not a forward slash:
>> GLOBAL-7XQWMEEO\SQL2000
>>
>> I did not put that in there, the system does and it works fine.
>>
>> --
>> 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:46bb7fab$0$20612$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%233QlHYs2HHA.5360@.TK2MSFTNGP03.phx.gbl...
>> When you use SSMS to connect to each of those instances while logged
>> on
>> locally, what do you type into the Server text box? For the default
>> (2005)
>> instance, it should be a dot. For the SQL 2000 instance, it should be
>> .\SQL2000. Have you tried that?
>>
>>
>> I type in nothing. All the fields are already filled in.
>> Server Type: Database Engine
>> Server name: GLOBAL-7XQWMEEO or GLOBAL-7XQWMEEO/SQL2000
>> Authentication: "my login user name"
>>
>> --
>> 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:46bb79ce$0$20536$4c368faf@.roadrunner.com...
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%230Pwo%23r2HHA.2752@.TK2MSFTNGP06.phx.gbl...
>> OK, so you can connect to both of the following:
>> .
>> .\SQL2000
>> Correct?
>>
>> I am familair with mySQL, but not MS SQL, so I do not know about the
>> reference you make concerning the way you are showing to connect.
>>
>> --
>> 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:46bb7068$0$30668$4c368faf@.roadrunner.com...
>> 2005 is default while "SQL2000" is the named.
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23qJopKr2HHA.4184@.TK2MSFTNGP06.phx.gbl...
>>> Which is the default instance and which is the named instance?
>>>
>>> --
>>> 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:46bb27ce$0$8961$4c368faf@.roadrunner.com...
>>> Two. local (SQL 2005 Std) and SQL2000 (SQL 2000)
>>>
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23pE5YXn2HHA.1164@.TK2MSFTNGP02.phx.gbl...
>>> Now I'm more confused. How many instances are on the box? If it's
>>> more
>>> than one, which SQL Servers are they and what are the instance
>>> names?
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba8b75$0$20593$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:eZI09Ej2HHA.5164@.TK2MSFTNGP05.phx.gbl...
>>> Dunno what to say. Can't troubleshoot without it being there. I
>>> guess
>>> you
>>> could always add a 2005 instance and see if you can repro it.
>>>
>>>
>>>
>>>
>>> The local is the 2005 instance while "SQL2000" is the 2000 SQL
>>> instance.
>>>
>>> --
>>> 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" <geek@.boy.com> wrote in message
>>> news:46ba775e$0$28682$4c368faf@.roadrunner.com...
>>>
>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>> news:%23WZyzRi2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>>> Was ASP running on the same box or a different one?
>>>
>>>
>>> Same one.
>>>
>>>
>>>>
>>>> --
>>>> 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:46ba688f$0$12176$4c368faf@.roadrunner.com...
>>>>
>>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>>> news:erV3U6h2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>>>> OK, I'm a bit lost now. You can connect now, right? You have
>>>> only
>>>> one
>>>> instance on the box now and it's SQL 2000, right? You're just
>>>> asking
>>>> what
>>>> the problem was when logging into a SQL 2005 instance with SSMS?
>>>> I
>>>> guess
>>>> since the instance is gone, we won't be able to troubleshoot
>>>> that
>>>> one.
>>>>
>>>> I have 2 instances running.
>>>> The SQL2000 one was not running because in the services it was
>>>> set
>>>> to
>>>> manual
>>>> start.
>>>> So now I have both of them running.
>>>>
>>>> I have not had any problem with SSMS, it was with ASP logging in
>>>> using
>>>> an
>>>> SQL account.
>>>>
>>>> Strange thing is I set up the database up using SSMS on version 9
>>>> (2005)
>>>> SQL
>>>> server.
>>>>
>>>> So now I don't know what is going on.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> 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:46ba5ae7$0$30652$4c368faf@.roadrunner.com...
>>>>
>>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>>>> news:%23yDpFEh2HHA.1184@.TK2MSFTNGP04.phx.gbl...
>>>> 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:
>>>>
>>>>
>>>> I don't type in anything. The boxes are already filled in and
>>>> logg
>>>> in
>>>> using
>>>> a user account that has admin privleges.
>>>>
>>>> never mind. Gosh how stupid.
>>>> The SQL2000 instance was not running in the services.
>>>>
>>>> However, it still does not explain why I could not use 2005 to
>>>> log
>>>> in
>>>> with
>>>> the the first error I received.
>>>>
>>>> .
>>>>
>>>> --
>>>> 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...
>>>>> 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...
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment