Protect DataBAse which is distributed on many SQL Servers

Hi,
I need to protect SQL Server 2000 database which I will distrubute to many
of my customers on their own SQL Servers. Unfortunately I still can't find a
way to solve this issue. Would you please help me with this?
Many thanks in advance!
Best regards,
Mariyan GotsevProtect in what way? What is it exactly you wish to prevent?
Andrew J. Kelly SQL MVP
"Mariyan" <mgms@.dir.bg> wrote in message
news:OblbpQPxDHA.2340@.TK2MSFTNGP12.phx.gbl...

quote:

---

>
> --
> Hi,
> I need to protect SQL Server 2000 database which I will distrubute to many
> of my customers on their own SQL Servers. Unfortunately I still can't find

---

a

quote:

---

> way to solve this issue. Would you please help me with this?
> Many thanks in advance!
> Best regards,
> Mariyan Gotsev
>
>

---

|||If you want to protect sql code of your procedures, triggers and views you
can use SQL Shield. http://www.activecrypt.com/sqlshield_howto.html|||Hi,
I have an application true which I want database to be available only. I
need to prevent every one of my customers from any access to the data in
the database, as there I put important customer information and customer
related restrictions - do the customer have rights to use some application
modules or not like example. What I need is very similar to MS Access
database password. You just can't open the database on every one machine if
you have not the database password. But for SQL Server this simple
protection seems to be much more difficult to implement. Please help me.
Many thanks!
Best regards,
Mariyan Gotsev
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:%2344QlrRxDHA.4060@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Protect in what way? What is it exactly you wish to prevent?
> --
> Andrew J. Kelly SQL MVP
>
> "Mariyan" <mgms@.dir.bg> wrote in message
> news:OblbpQPxDHA.2340@.TK2MSFTNGP12.phx.gbl...
many[QUOTE]
find[QUOTE]
> a
>

---

|||Hi,
I have an application true which I want database to be available only. I
need to prevent every one of my customers from any access to the data in
the database, as there I put important customer information and customer
related restrictions - do the customer have rights to use some application
modules or not like example. What I need is very similar to MS Access
database password. You just can't open the database on every one machine if
you have not the database password. But for SQL Server this simple
protection seems to be much more difficult to implement. Please help me.
Many thanks!
Best regards,
Mariyan Gotsev
"Andrey Kubyshev" <email.ANTISPAM@.vtc.ru> wrote in message
news:brrq4s$ep3$02$1@.news.t-online.com...

quote:

---

> If you want to protect sql code of your procedures, triggers and views you
> can use SQL Shield. http://www.activecrypt.com/sqlshield_howto.html
>

---

|||To gain access to the database, you need a login defined with access
granted to a particular database. This is similar to Accessing
a secured Access database. Local machine admins by default have sysadmin
permission. You can change this:
http://www.microsoft.com/sql/techin...ration/May3.asp
If you're distributing your application with MSDE, you can disable all
network protocols during the install.
This means that only a locally logged on user can access the database.
See: DISABLENETWORKPROTOCOLS
810826 INF: New Switches in MSDE Service Pack 3 Setup
http://support.microsoft.com/?id=810826
You may want to consider using Application Roles to control security to the
database.
See: Establishing Application Security and Application Roles in SQL Books
Online.
In addition you should read this technet article before deploying your
application.
http://www.microsoft.com/technet/tr...chnet/prodtechn
ol/sql/maintain/security/sp3sec/SP3SEC03.ASP
Some addtional checklists :
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/CL_SecDBSe.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Proprties not imported with Table

I am developing a DB with others in my group. When I import tables created on other servers to my server, the primary key and other properties do not import with the tables. Can anyone explain why this is happening? Is there a setting I have over looked?If you use DTS, make usre you use the Copy object(s) instead of Copy table(s) option.|||Nope...what method are you using to migrate the Data

Look at DTS transfer Database Task option

Or better yet, script the objects then build them...I prefer this method, and use bcp|||Originally posted by joejcheng
If you use DTS, make usre you use the Copy object(s) instead of Copy table(s) option.
The copy object worked ... Thanks

Properly connecting to multiple instancesof SQL servers

Hello.
I did some changes to my server and now having trouble with connections.
Took off SQL 2000 and replaced it with SQL2005 Standard.
Got one web site with the following connection via ASP:
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Data Source=(local);Provider=SQLOLEDB.1;Initial
Catalog=Motorhome;UID=xxxxxxxx;Password=xxxxxx"
%>
This produces "Login Failed" and kept doing it no matter what I have changed
in SQL 2005.
After trying to connect with numerous failing trys, I put SQL 2000 back on.
I gave it the new instance name of SQL2000.
I tried the above, and also chaned it to the follow connections:
(GLOBAL-7XQWMEEO\SQL2000)
&
(SQL2000)
These two produced the error - "Server does not exist or access denied" and
'local' still produces "login failed."
What is the correct method?
Thanks,
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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>