Program Connection: multiple

Showing posts with label multiple. Show all posts

Friday, March 30, 2012

Pros and cons of having multiple DBMS in the organization

I just want to know how does a database manager go about with having
multiple RDBMS in the organization. As we acquire new companies and have to
manage them all ( Im not a manager, but would like to be some day) , what do
great database managers do? Do they just begin to choose one and how do they
go about finding the right one ? Or do they prefer to just leave them as is
..
Can you give me some pros and cons of having multiple RDBMS and what one
should do ? Any articles out there that I could read. Right now, we have SQL
Server,Oracle,DB2,Postgres and some mysql as well. Each business that we
acquire is a stand alone entity but managers tend to be operate them all
under one umbrella.
Please advice.
ThanksWe have a similar situation , with a client at the moment . They are
acquiring companies which all have different db and web apps. Currently, we
are managing SQL7,2000,2005 - Oracle 10 and mysql . After in depth analysis,
they've decided to keep every system separate and build an Integration
service based around SQL Server. This will have a bunch of filters to import
relevant data.
The main reason for a central integration server, is that they are in the
process of acquiring more companies with all sorts of other dbms, and
therefore have to build a structure to integrate future disparate systems
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Hassan" <Hassan@.hotmail.com> wrote in message
news:#6X#Tv1jGHA.3780@.TK2MSFTNGP03.phx.gbl...
> I just want to know how does a database manager go about with having
> multiple RDBMS in the organization. As we acquire new companies and have
to
> manage them all ( Im not a manager, but would like to be some day) , what
do
> great database managers do? Do they just begin to choose one and how do
they
> go about finding the right one ? Or do they prefer to just leave them as
is
> ..
> Can you give me some pros and cons of having multiple RDBMS and what one
> should do ? Any articles out there that I could read. Right now, we have
SQL
> Server,Oracle,DB2,Postgres and some mysql as well. Each business that we
> acquire is a stand alone entity but managers tend to be operate them all
> under one umbrella.
> Please advice.
> Thanks
>|||Hassan
If you woork for a large company, it is inevitable that you will end up with
multiple RDBMS and indeed multiple most things. I work for a large
international bank and we have multiple RDBMS on multiple platforms.
When I joined the company they were actively trying to get rid of SQL
Server. Their databases of choice were DB2 on the mainframe and Oracle on
distributed systems. The policy was to convert all SQL Server systems to
either DB2 or Oracle. They soon found this to be an unrealistic policy due t
o
the popularity of SQL Server. For every SQL Server system they managed to
convert two or three more took it's place.
More recently we accquired some companies that use Sybase, and we now have a
small Sybase team.
How you manage all these RDBMS teams is up to you. I have worked for a
company that had a central database management team and they were responsibl
e
for all RDBMS within the company. Where I work now they split them between
mainframe and distributed.
I don't know that I have really offered any help here, more just to let you
know it is a very common situation.
Regards
John
"Hassan" wrote:

> I just want to know how does a database manager go about with having
> multiple RDBMS in the organization. As we acquire new companies and have t
o
> manage them all ( Im not a manager, but would like to be some day) , what
do
> great database managers do? Do they just begin to choose one and how do th
ey
> go about finding the right one ? Or do they prefer to just leave them as i
s
> ...
> Can you give me some pros and cons of having multiple RDBMS and what one
> should do ? Any articles out there that I could read. Right now, we have S
QL
> Server,Oracle,DB2,Postgres and some mysql as well. Each business that we
> acquire is a stand alone entity but managers tend to be operate them all
> under one umbrella.
> Please advice.
> Thanks
>
>|||We have a similar situation , with a client at the moment . They are
acquiring companies which all have different db and web apps. Currently, we
are managing SQL7,2000,2005 - Oracle 10 and mysql . After in depth analysis,
they've decided to keep every system separate and build an Integration
service based around SQL Server. This will have a bunch of filters to import
relevant data.
The main reason for a central integration server, is that they are in the
process of acquiring more companies with all sorts of other dbms, and
therefore have to build a structure to integrate future disparate systems
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Hassan" <Hassan@.hotmail.com> wrote in message
news:#6X#Tv1jGHA.3780@.TK2MSFTNGP03.phx.gbl...
> I just want to know how does a database manager go about with having
> multiple RDBMS in the organization. As we acquire new companies and have
to
> manage them all ( Im not a manager, but would like to be some day) , what
do
> great database managers do? Do they just begin to choose one and how do
they
> go about finding the right one ? Or do they prefer to just leave them as
is
> ..
> Can you give me some pros and cons of having multiple RDBMS and what one
> should do ? Any articles out there that I could read. Right now, we have
SQL
> Server,Oracle,DB2,Postgres and some mysql as well. Each business that we
> acquire is a stand alone entity but managers tend to be operate them all
> under one umbrella.
> Please advice.
> Thanks
>|||Hassan
If you woork for a large company, it is inevitable that you will end up with
multiple RDBMS and indeed multiple most things. I work for a large
international bank and we have multiple RDBMS on multiple platforms.
When I joined the company they were actively trying to get rid of SQL
Server. Their databases of choice were DB2 on the mainframe and Oracle on
distributed systems. The policy was to convert all SQL Server systems to
either DB2 or Oracle. They soon found this to be an unrealistic policy due t
o
the popularity of SQL Server. For every SQL Server system they managed to
convert two or three more took it's place.
More recently we accquired some companies that use Sybase, and we now have a
small Sybase team.
How you manage all these RDBMS teams is up to you. I have worked for a
company that had a central database management team and they were responsibl
e
for all RDBMS within the company. Where I work now they split them between
mainframe and distributed.
I don't know that I have really offered any help here, more just to let you
know it is a very common situation.
Regards
John
"Hassan" wrote:

> I just want to know how does a database manager go about with having
> multiple RDBMS in the organization. As we acquire new companies and have t
o
> manage them all ( Im not a manager, but would like to be some day) , what
do
> great database managers do? Do they just begin to choose one and how do th
ey
> go about finding the right one ? Or do they prefer to just leave them as i
s
> ...
> Can you give me some pros and cons of having multiple RDBMS and what one
> should do ? Any articles out there that I could read. Right now, we have S
QL
> Server,Oracle,DB2,Postgres and some mysql as well. Each business that we
> acquire is a stand alone entity but managers tend to be operate them all
> under one umbrella.
> Please advice.
> Thanks
>
>|||One common approach in large companies is to standardize on a strategic DBMS
platform in each of the mainframe, Unix/Linux, and Windows environments. It'
s
not uncommon for a company to choose DB2 on mainframe, Oracle on Unix/Linux,
and SQL Server on Windows as its startegic DBMS platforms and consider any
other DBMS platforms as legacy platforms. The company may strongly discourag
e
or even ban any new development on any other DBMS platform, and either inves
t
to migrate existing databases from other DBMS platforms to one of these thre
e
or simply sunset the them.
In decisions like this, DBMS-specific factors count for very little.
Linchi
"Hassan" wrote:

> I just want to know how does a database manager go about with having
> multiple RDBMS in the organization. As we acquire new companies and have t
o
> manage them all ( Im not a manager, but would like to be some day) , what
do
> great database managers do? Do they just begin to choose one and how do th
ey
> go about finding the right one ? Or do they prefer to just leave them as i
s
> ...
> Can you give me some pros and cons of having multiple RDBMS and what one
> should do ? Any articles out there that I could read. Right now, we have S
QL
> Server,Oracle,DB2,Postgres and some mysql as well. Each business that we
> acquire is a stand alone entity but managers tend to be operate them all
> under one umbrella.
> Please advice.
> Thanks
>
>|||One common approach in large companies is to standardize on a strategic DBMS
platform in each of the mainframe, Unix/Linux, and Windows environments. It'
s
not uncommon for a company to choose DB2 on mainframe, Oracle on Unix/Linux,
and SQL Server on Windows as its startegic DBMS platforms and consider any
other DBMS platforms as legacy platforms. The company may strongly discourag
e
or even ban any new development on any other DBMS platform, and either inves
t
to migrate existing databases from other DBMS platforms to one of these thre
e
or simply sunset the them.
In decisions like this, DBMS-specific factors count for very little.
Linchi
"Hassan" wrote:

> I just want to know how does a database manager go about with having
> multiple RDBMS in the organization. As we acquire new companies and have t
o
> manage them all ( Im not a manager, but would like to be some day) , what
do
> great database managers do? Do they just begin to choose one and how do th
ey
> go about finding the right one ? Or do they prefer to just leave them as i
s
> ...
> Can you give me some pros and cons of having multiple RDBMS and what one
> should do ? Any articles out there that I could read. Right now, we have S
QL
> Server,Oracle,DB2,Postgres and some mysql as well. Each business that we
> acquire is a stand alone entity but managers tend to be operate them all
> under one umbrella.
> Please advice.
> Thanks
>
>

Pros and cons of having multiple DBMS in the organization

proportional fill using multiple files

As part of my ongoing testing of the performance impact of multiple
files vs. a single file. (Here is the link, comments would be
appreciated http://linktrim.com/yq) I have come across some
inconsistencies in how "proportional fill" works. According to books
online
"Filegroups use a proportional fill strategy across all the files
within each filegroup. As data is written to the filegroup, Microsoft=AE
SQL Server=99 2000 writes an amount proportional to the free space in
the file to each file within the filegroup, rather than writing all the
data to the first file until full, and then writing to the next file.
For example, if file f1 has 100 megabytes (MB) free and file f2 has 200
MB free, one extent is allocated from file f1, two extents from file
f2, and so on. This way both files become full at about the same time,
and simple striping is achieved."
Based on some of my testing this is not what is occurring. I created 3
files in one filegroup for my DB. The first number is the file size,
the second number is the used size after the data load.
1=2E Test one
File1 - 3000 - 520
File2 - 2000 - 520
File3 - 2000 - 520
2=2E Test two
File1 - 3000 - 293
File2 - 2000 - 293
File3 - 3000 - 293
3=2E Test three
File1 - 4000 - 416
File2 - 2000 - 232
File3 - 2000 - 232
As you can see in test one and two the used size is the same across
files even thought the 3 data files are not the same size. Not until I
make one file twice as large as the others did I sea difference in
used space.
Can anyone explain this behavior?
BertWere all the files completely empty? What size is that in? Is it MB's,
GBs, KBs etc?
--
Andrew J. Kelly SQL MVP
"bert" <bertcord@.gmail.com> wrote in message
news:1107271506.112735.198080@.f14g2000cwb.googlegroups.com...
As part of my ongoing testing of the performance impact of multiple
files vs. a single file. (Here is the link, comments would be
appreciated http://linktrim.com/yq) I have come across some
inconsistencies in how "proportional fill" works. According to books
online
"Filegroups use a proportional fill strategy across all the files
within each filegroup. As data is written to the filegroup, Microsoft®
SQL ServerT 2000 writes an amount proportional to the free space in
the file to each file within the filegroup, rather than writing all the
data to the first file until full, and then writing to the next file.
For example, if file f1 has 100 megabytes (MB) free and file f2 has 200
MB free, one extent is allocated from file f1, two extents from file
f2, and so on. This way both files become full at about the same time,
and simple striping is achieved."
Based on some of my testing this is not what is occurring. I created 3
files in one filegroup for my DB. The first number is the file size,
the second number is the used size after the data load.
1. Test one
File1 - 3000 - 520
File2 - 2000 - 520
File3 - 2000 - 520
2. Test two
File1 - 3000 - 293
File2 - 2000 - 293
File3 - 3000 - 293
3. Test three
File1 - 4000 - 416
File2 - 2000 - 232
File3 - 2000 - 232
As you can see in test one and two the used size is the same across
files even thought the 3 data files are not the same size. Not until I
make one file twice as large as the others did I sea difference in
used space.
Can anyone explain this behavior?
Bert|||Hey Andrew thanks for taking the time to respond. Yes the files were
completely empty, and the size is in MB. Here is the DDL for the
table.
CREATE DATABASE [testdb]
ON (NAME = N'testdb_Data',
FILENAME = N'e:\sqldata\mssql\data\testdb_Data.MDF' ,
SIZE = 3000, FILEGROWTH = 10%), (NAME = N'testdb_Data1',
FILENAME = N'e:\sqldata\mssql\data\testdb_Data1.NDF' ,
SIZE = 2000, FILEGROWTH = 10%), (NAME = N'testdb_Data2',
FILENAME = N'e:\sqldata\mssql\data\testdb_Data2.NDF' ,
SIZE = 3000, FILEGROWTH = 10%) LOG ON (NAME = N'testdb_Log',
FILENAME = N'g:\sqldata\mssql\data\testdb_Log.LDF' ,
SIZE = 500, FILEGROWTH = 10%)
I reran the tests a second time as I was wondering if checking the
batch size for my bulk insert would have an affect. I ran the test
twice once without setting the batch size and a second time of setting
the batch size of 10000. Both tests resulted in the data files being
filled equally, even though the second file is smaller than the others.|||OK this is a guess but makes a lot of sense when you think about it. The
results you had are listed below. Since the files are filled at the extent
level it can't split an extent and put half in one file and half in another.
So in your tests until you get differences in free space that are exact
multiples of each other it will round down. So with a file size of 2000
(file2) and 3000 (file3) it would allocate one extent to file 2 and one to
file 3. When you get double the free space as in File1 and file 2 it can
then allocate in a 2 to 1 fashion. I believe the algorithm has to be very
simple to keep it efficient. That and the fact it allocates in extents lend
to the behavior you see.
1. Test one
File1 - 3000 - 520
File2 - 2000 - 520
File3 - 2000 - 520
2. Test two
File1 - 3000 - 293
File2 - 2000 - 293
File3 - 3000 - 293
3. Test three
File1 - 4000 - 416
File2 - 2000 - 232
File3 - 2000 - 232
Andrew J. Kelly SQL MVP
"bert" <bertcord@.gmail.com> wrote in message
news:1107287428.961190.60820@.z14g2000cwz.googlegroups.com...
> Hey Andrew thanks for taking the time to respond. Yes the files were
> completely empty, and the size is in MB. Here is the DDL for the
> table.
> CREATE DATABASE [testdb]
> ON (NAME = N'testdb_Data',
> FILENAME = N'e:\sqldata\mssql\data\testdb_Data.MDF' ,
> SIZE = 3000, FILEGROWTH = 10%), (NAME = N'testdb_Data1',
> FILENAME = N'e:\sqldata\mssql\data\testdb_Data1.NDF' ,
> SIZE = 2000, FILEGROWTH = 10%), (NAME = N'testdb_Data2',
> FILENAME = N'e:\sqldata\mssql\data\testdb_Data2.NDF' ,
> SIZE = 3000, FILEGROWTH = 10%) LOG ON (NAME = N'testdb_Log',
> FILENAME = N'g:\sqldata\mssql\data\testdb_Log.LDF' ,
> SIZE = 500, FILEGROWTH = 10%)
> I reran the tests a second time as I was wondering if checking the
> batch size for my bulk insert would have an affect. I ran the test
> twice once without setting the batch size and a second time of setting
> the batch size of 10000. Both tests resulted in the data files being
> filled equally, even though the second file is smaller than the others.
>|||This is correct. In test 1, if you keep adding data, when the remaining free
space in file 1 versus file 2 become a ratio of 2:1, then we allocate 2
pages in file 1 for every page in file 2.
Please also note that when file becomes very large or when there are a lot
of concurrent transactions, we use some performance improvement technique
with a side effect that the free space calculation is not 100% accurate.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eHQruWNCFHA.2072@.TK2MSFTNGP10.phx.gbl...
> OK this is a guess but makes a lot of sense when you think about it. The
> results you had are listed below. Since the files are filled at the
> extent level it can't split an extent and put half in one file and half in
> another. So in your tests until you get differences in free space that are
> exact multiples of each other it will round down. So with a file size of
> 2000 (file2) and 3000 (file3) it would allocate one extent to file 2 and
> one to file 3. When you get double the free space as in File1 and file 2
> it can then allocate in a 2 to 1 fashion. I believe the algorithm has to
> be very simple to keep it efficient. That and the fact it allocates in
> extents lend to the behavior you see.
> 1. Test one
> File1 - 3000 - 520
> File2 - 2000 - 520
> File3 - 2000 - 520
> 2. Test two
> File1 - 3000 - 293
> File2 - 2000 - 293
> File3 - 3000 - 293
> 3. Test three
> File1 - 4000 - 416
> File2 - 2000 - 232
> File3 - 2000 - 232
>
> --
> Andrew J. Kelly SQL MVP
>
> "bert" <bertcord@.gmail.com> wrote in message
> news:1107287428.961190.60820@.z14g2000cwz.googlegroups.com...
>> Hey Andrew thanks for taking the time to respond. Yes the files were
>> completely empty, and the size is in MB. Here is the DDL for the
>> table.
>> CREATE DATABASE [testdb]
>> ON (NAME = N'testdb_Data',
>> FILENAME = N'e:\sqldata\mssql\data\testdb_Data.MDF' ,
>> SIZE = 3000, FILEGROWTH = 10%), (NAME = N'testdb_Data1',
>> FILENAME = N'e:\sqldata\mssql\data\testdb_Data1.NDF' ,
>> SIZE = 2000, FILEGROWTH = 10%), (NAME = N'testdb_Data2',
>> FILENAME = N'e:\sqldata\mssql\data\testdb_Data2.NDF' ,
>> SIZE = 3000, FILEGROWTH = 10%) LOG ON (NAME = N'testdb_Log',
>> FILENAME = N'g:\sqldata\mssql\data\testdb_Log.LDF' ,
>> SIZE = 500, FILEGROWTH = 10%)
>> I reran the tests a second time as I was wondering if checking the
>> batch size for my bulk insert would have an affect. I ran the test
>> twice once without setting the batch size and a second time of setting
>> the batch size of 10000. Both tests resulted in the data files being
>> filled equally, even though the second file is smaller than the others.
>|||Ok I see so basically it will write equal pages to the files until the
free space is at a 2:1 ration. I wasn't thinking about it on an extent
by extent basis. I was thinking that the end result could be
calculated as such.
(FileSize/TotalFileGroupSizeFreeSpace) * TotalDataToLoad
So in this example
File1 - 3000 - 293
File2 - 2000 - 293
File3 - 3000 - 293
Results should be
File1 - 3000 - 329.625
File2 - 2000 - 219.75
File3 - 3000 - 329.625
Wei maybe you can answer this... as data is allocated at what level is
it determined what file should be written to? IS it at the extent
level? When using multiple files are teh extents grouped into larger
chunks based on file?
bert|||Bert,
There are no cases that I know of where you would break apart an extent.
Each extent always has 8 pages allocated to it (whether or not they all
include data). An extent may have pages from multiple objects (Mixed
Extent) but this is rare and only used when the object has less than 8
pages. You can read and write at the page level but the page always lives
on an extent. So if you are writing to a file and the current extent is full
it will create a new extent in the proper file and begin writing to it. It
will not write half an extent here and half there so to speak.
Andrew J. Kelly SQL MVP
"bert" <bertcord@.gmail.com> wrote in message
news:1107362088.012050.183690@.l41g2000cwc.googlegroups.com...
> Ok I see so basically it will write equal pages to the files until the
> free space is at a 2:1 ration. I wasn't thinking about it on an extent
> by extent basis. I was thinking that the end result could be
> calculated as such.
> (FileSize/TotalFileGroupSizeFreeSpace) * TotalDataToLoad
> So in this example
> File1 - 3000 - 293
> File2 - 2000 - 293
> File3 - 3000 - 293
> Results should be
> File1 - 3000 - 329.625
> File2 - 2000 - 219.75
> File3 - 3000 - 329.625
> Wei maybe you can answer this... as data is allocated at what level is
> it determined what file should be written to? IS it at the extent
> level? When using multiple files are teh extents grouped into larger
> chunks based on file?
> bert
>|||I was wondering if it does the opposite...not smaller than an extent
but if the proportional fill ever allocates in groups of extents. For
example under load will it write 4 extents to file1 and then 4 extents
to file2 or does it always go extent by extent switching between files.
I am trying to figure out the best configuration for my new server. I
have a database that is about 3TB in size. We currently load about
300-500 million records a month into several tables and want to make
sure I set up the files and file groups correctly.
My new server has 2 PERC4 cards with 2 channels each. Each channel has
a RAID10 array that are each 1TB in size, this gives me four drives
with 1TB each F,G on one channel and H,I on another. I have other
drives for tempdb and tlog that are mirrors.
We are using partitioned tables for data with new tables created each
month.
The strategy I am leaning towards is as follows.
When new tables are created create 2 new file groups. For this month
they would be FebuaryData and FeburaryIndex, create one file in each
filegroup
F:\ FebuaryData
H:\ FeburaryIndex
Next month I would create
G:\MarchData
I:\MarchIndex
What I am trying to determine if there is any advantage to creating
multiple files within each file group, for example.
F:\ FebuaryData-File1
H:\ FeburaryIndex-File1
G:\ FebuaryData-File2
I:\ FebuaryData-File2
F:\ FebuaryData1
H:\ FeburaryIndex1
G:\ FebuaryData2
I:\ FeburaryIndex2
The current database has multiple files located on the same drives. I
have already determined that this does not give better performance.
Any input would be appreciated
Thanks
Bert|||I suspect that it is possible they can allocate more than one extent at a
time per file when it makes sense. Wei Xiao said something to the effect
that they do make adjustments in certain circumstances. Is this going to
be a DW or a large OLTP system? Will you be doing more seeks or range
scans? I wouldn't worry as much about getting the data in as working with
it afterwards. While you may find that one technique is slightly faster
than others for loading the data it is usually a small percentage of the
overall time spent in a system. So one thing you need to decide is whether
the load time or the read time is more important. Then figure out how the
data will be read. If you do a lot of queries that scan ranges of indexes
it will most like benefit from separating the data from the indexes onto
different arrays. If you do a lot of scans (partially or totally) it may be
better to create 4 files for the filegroup and place one on each of the Raid
10's. Of coarse there are no hard and fast rules that you can ccount on in
this situation. It really depends a lot on how you use the data and most of
the time you can only find the optimal solution by trial and error. That
usually takes more time and resources than people want to give but that is
the way it goes. How long do you plan on keeping the data? Is it a yearly
process in which you drop one month out and bring in the next one? Having a
filegroup for each month in that case may not be too bad of an idea. It
allows you to backup at the filegroup level and that may help if the older
months don't have update activity. Again without knowing exactly how you
will use the data it's a guess but why only create 1 file per file group?
If you have 4 drives why not 2 files per FG and place 1 file on each drive.
Two for the indexes and 2 for the data.
--
Andrew J. Kelly SQL MVP
"bert" <bertcord@.gmail.com> wrote in message
news:1107403443.038720.258700@.c13g2000cwb.googlegroups.com...
>I was wondering if it does the opposite...not smaller than an extent
> but if the proportional fill ever allocates in groups of extents. For
> example under load will it write 4 extents to file1 and then 4 extents
> to file2 or does it always go extent by extent switching between files.
> I am trying to figure out the best configuration for my new server. I
> have a database that is about 3TB in size. We currently load about
> 300-500 million records a month into several tables and want to make
> sure I set up the files and file groups correctly.
> My new server has 2 PERC4 cards with 2 channels each. Each channel has
> a RAID10 array that are each 1TB in size, this gives me four drives
> with 1TB each F,G on one channel and H,I on another. I have other
> drives for tempdb and tlog that are mirrors.
> We are using partitioned tables for data with new tables created each
> month.
> The strategy I am leaning towards is as follows.
> When new tables are created create 2 new file groups. For this month
> they would be FebuaryData and FeburaryIndex, create one file in each
> filegroup
> F:\ FebuaryData
> H:\ FeburaryIndex
> Next month I would create
> G:\MarchData
> I:\MarchIndex
> What I am trying to determine if there is any advantage to creating
> multiple files within each file group, for example.
> F:\ FebuaryData-File1
> H:\ FeburaryIndex-File1
> G:\ FebuaryData-File2
> I:\ FebuaryData-File2
> F:\ FebuaryData1
> H:\ FeburaryIndex1
> G:\ FebuaryData2
> I:\ FeburaryIndex2
> The current database has multiple files located on the same drives. I
> have already determined that this does not give better performance.
> Any input would be appreciated
> Thanks
> Bert
>|||>>I suspect that it is possible they can allocate more than one extent
at a
>>time per file when it makes sense.
I guess the main thing I wanted to know is when they would fill at
differnet rates. IT makes it import to plan ahead as I dont want to
run in to a situation where I have the files spread out but they are
not being written to at the same rate. Would make it hard to plan for
space.
>>Is this going to be a DW or a large OLTP system?
OLTP, the system will do real time processing of firewall and ids event
data. A set of queries will always be runnign processing the data and
looking for attackers.
>>How long do you plan on keeping the data? Is it a yearly
>>process in which you drop one month out and bring in the next one?
yep that is what we are doing. This is actually one of 4 servers that
will be loading and processing the same data. We are going to set up
the other servers to act as our "backup" and they will use differnet
indexing stratagies. This is why I am spending so much time trying to
make sure I make the right file layout choice.
>>why only create 1 file per file group
Some of our queries will span several months. With 4 drives I was
thinking I could have month1 on adrive Index 1 on another and then do
the same for month 2. After thinking about this some more and looking
at some of the query patterns I have determined that most queries
target data in the last month so this layout would not be ideal.
Ok last question for you ;) ... I have decided on using 2 FileGroups
for now. LargeTables and LargeTablesIndex do I ...
A. Each FileGroup gets one file on each array for a total of eight
files
Pro - Extra Files distribute teh IO across all disk
Con - Index IO could impact Table IO and vs versa
F:\ LargeTables - File1, LargeTablesIndex -File1
H:\ LargeTables - File2, LargeTablesIndex -File1
G:\ LargeTables - File3, LargeTablesIndex -File1
I:\ LargeTables - File4, LargeTablesIndex -File1
B. Each Filegroup has 2 dedicated arrays
Pro - EAch filegroup has dedicated drives
Con - Not fully utilizing resources
F:\ LargeTables - File1
H:\ LargeTables - File2
G:\ LargeTablesIndex -File1
I:\ LargeTablesIndex -File1
I think I am leaning towards A... I am also going to perform some more
tests to back up this theory. I am almost done writing a multi
threading utility that can be used to load test the DB once this is
done it will make my testing much easier|||>>I suspect that it is possible they can allocate more than one extent
at a
>>time per file when it makes sense.
I guess the main thing I wanted to know is when they would fill at
differnet rates. IT makes it import to plan ahead as I dont want to
run in to a situation where I have the files spread out but they are
not being written to at the same rate. Would make it hard to plan for
space.
>>Is this going to be a DW or a large OLTP system?
OLTP, the system will do real time processing of firewall and ids event
data. A set of queries will always be runnign processing the data and
looking for attackers.
>>How long do you plan on keeping the data? Is it a yearly
>>process in which you drop one month out and bring in the next one?
yep that is what we are doing. This is actually one of 4 servers that
will be loading and processing the same data. We are going to set up
the other servers to act as our "backup" and they will use differnet
indexing stratagies. This is why I am spending so much time trying to
make sure I make the right file layout choice.
>>why only create 1 file per file group
Some of our queries will span several months. With 4 drives I was
thinking I could have month1 on adrive Index 1 on another and then do
the same for month 2. After thinking about this some more and looking
at some of the query patterns I have determined that most queries
target data in the last month so this layout would not be ideal.
Ok last question for you ;) ... I have decided on using 2 FileGroups
for now. LargeTables and LargeTablesIndex do I ...
A. Each FileGroup gets one file on each array for a total of eight
files
Pro - Extra Files distribute teh IO across all disk
Con - Index IO could impact Table IO and vs versa
F:\ LargeTables - File1, LargeTablesIndex -File1
H:\ LargeTables - File2, LargeTablesIndex -File1
G:\ LargeTables - File3, LargeTablesIndex -File1
I:\ LargeTables - File4, LargeTablesIndex -File1
B. Each Filegroup has 2 dedicated arrays
Pro - EAch filegroup has dedicated drives
Con - Not fully utilizing resources
F:\ LargeTables - File1
H:\ LargeTables - File2
G:\ LargeTablesIndex -File1
I:\ LargeTablesIndex -File1
I think I am leaning towards A... I am also going to perform some more
tests to back up this theory. I am almost done writing a multi
threading utility that can be used to load test the DB once this is
done it will make my testing much easier|||>>I suspect that it is possible they can allocate more than one extent
at a
>>time per file when it makes sense.
I guess the main thing I wanted to know is when they would fill at
differnet rates. IT makes it import to plan ahead as I dont want to
run in to a situation where I have the files spread out but they are
not being written to at the same rate. Would make it hard to plan for
space.
>>Is this going to be a DW or a large OLTP system?
OLTP, the system will do real time processing of firewall and ids event
data. A set of queries will always be runnign processing the data and
looking for attackers.
>>How long do you plan on keeping the data? Is it a yearly
>>process in which you drop one month out and bring in the next one?
yep that is what we are doing. This is actually one of 4 servers that
will be loading and processing the same data. We are going to set up
the other servers to act as our "backup" and they will use differnet
indexing stratagies. This is why I am spending so much time trying to
make sure I make the right file layout choice.
>>why only create 1 file per file group
Some of our queries will span several months. With 4 drives I was
thinking I could have month1 on adrive Index 1 on another and then do
the same for month 2. After thinking about this some more and looking
at some of the query patterns I have determined that most queries
target data in the last month so this layout would not be ideal.
Ok last question for you ;) ... I have decided on using 2 FileGroups
for now. LargeTables and LargeTablesIndex do I ...
A. Each FileGroup gets one file on each array for a total of eight
files
Pro - Extra Files distribute teh IO across all disk
Con - Index IO could impact Table IO and vs versa
F:\ LargeTables - File1, LargeTablesIndex -File1
H:\ LargeTables - File2, LargeTablesIndex -File1
G:\ LargeTables - File3, LargeTablesIndex -File1
I:\ LargeTables - File4, LargeTablesIndex -File1
B. Each Filegroup has 2 dedicated arrays
Pro - EAch filegroup has dedicated drives
Con - Not fully utilizing resources
F:\ LargeTables - File1
H:\ LargeTables - File2
G:\ LargeTablesIndex -File1
I:\ LargeTablesIndex -File1
I think I am leaning towards A... I am also going to perform some more
tests to back up this theory. I am almost done writing a multi
threading utility that can be used to load test the DB once this is
done it will make my testing much easier|||>>I suspect that it is possible they can allocate more than one extent
at a
>>time per file when it makes sense.
I guess the main thing I wanted to know is when they would fill at
differnet rates. IT makes it import to plan ahead as I dont want to
run in to a situation where I have the files spread out but they are
not being written to at the same rate. Would make it hard to plan for
space.
>>Is this going to be a DW or a large OLTP system?
OLTP, the system will do real time processing of firewall and ids event
data. A set of queries will always be runnign processing the data and
looking for attackers.
>>How long do you plan on keeping the data? Is it a yearly
>>process in which you drop one month out and bring in the next one?
yep that is what we are doing. This is actually one of 4 servers that
will be loading and processing the same data. We are going to set up
the other servers to act as our "backup" and they will use differnet
indexing stratagies. This is why I am spending so much time trying to
make sure I make the right file layout choice.
>>why only create 1 file per file group
Some of our queries will span several months. With 4 drives I was
thinking I could have month1 on adrive Index 1 on another and then do
the same for month 2. After thinking about this some more and looking
at some of the query patterns I have determined that most queries
target data in the last month so this layout would not be ideal.
Ok last question for you ;) ... I have decided on using 2 FileGroups
for now. LargeTables and LargeTablesIndex do I ...
A. Each FileGroup gets one file on each array for a total of eight
files
Pro - Extra Files distribute teh IO across all disk
Con - Index IO could impact Table IO and vs versa
F:\ LargeTables - File1, LargeTablesIndex -File1
H:\ LargeTables - File2, LargeTablesIndex -File1
G:\ LargeTables - File3, LargeTablesIndex -File1
I:\ LargeTables - File4, LargeTablesIndex -File1
B. Each Filegroup has 2 dedicated arrays
Pro - EAch filegroup has dedicated drives
Con - Not fully utilizing resources
F:\ LargeTables - File1
H:\ LargeTables - File2
G:\ LargeTablesIndex -File1
I:\ LargeTablesIndex -File1
I think I am leaning towards A... I am also going to perform some more
tests to back up this theory. I am almost done writing a multi
threading utility that can be used to load test the DB once this is
done it will make my testing much easier|||> Ok last question for you ;) ... I have decided on using 2 FileGroups
> for now. LargeTables and LargeTablesIndex do I ...
> A. Each FileGroup gets one file on each array for a total of eight
> files
> Pro - Extra Files distribute teh IO across all disk
> Con - Index IO could impact Table IO and vs versa
> F:\ LargeTables - File1, LargeTablesIndex -File1
> H:\ LargeTables - File2, LargeTablesIndex -File1
> G:\ LargeTables - File3, LargeTablesIndex -File1
> I:\ LargeTables - File4, LargeTablesIndex -File1
> B. Each Filegroup has 2 dedicated arrays
> Pro - EAch filegroup has dedicated drives
> Con - Not fully utilizing resources
> F:\ LargeTables - File1
> H:\ LargeTables - File2
> G:\ LargeTablesIndex -File1
> I:\ LargeTablesIndex -File1
>
Since you said this is going to be an OLTP you should be doing more seeks
than scans. That means relatively small amount of pages being read from
each file. So I would spread the files across all the array's as in choice
A. These are RAID 10's and the activity should be such that I am not sure
you would get as much benefit from dedicating two drives for indexes alone.
Your key is to make sure you have enough ram to mitigate the I/O anyway.
You are spending a lot of money on drives so make sure you give the memory
it's due as well. Have you considered using 64 bit at all? I am not saying
that it is the way to go, only that you should weigh it's pros and cons as
well. If you are doing lots of computations and need support for large
memory it can be a winner.
Andrew J. Kelly SQL MVP
"bert" <bertcord@.gmail.com> wrote in message
news:1107492155.518141.278920@.o13g2000cwo.googlegroups.com...|||>>Since you said this is going to be an OLTP you should be doing more
seeks
>>than scans.
Still lots of scnas... I guess I woudl call this a hybrid database.
Ever 24 hours about 30-50 millions rows are loaded. Most queries are
scanning this data.
>>You are spending a lot of money on drives so make sure you give the
memory
>>it's due as well.
We are starting with 8GB...hopefully this is enough.
>>Have you considered using 64 bit at all?
I would love to ;)...heck we are still running windows 2000... Other
reasons I am putting so much effort into measuring performance is so I
have a baseline to compare to. Once I get this server set up I think I
will finally have some time to start my WIn2003 and Yukon testing. I
finished my .Net app today...I call it the DBJammer. Very simple for
now but it creates two thread pools...one pool runs bulk inserts 2
threads at A time and the other pool fires of queries against the data
about 50 threads at a time. Hopefully I can use this to help get some
good metrics. I have heard that an upgrade to windows 2003 gives a
measurable performance gain as well.|||Absolutely you should use Win2003. It makes no sense to build a new app and
use Win2000. 2003 has many benefits to aide in performance across the
board.
--
Andrew J. Kelly SQL MVP
"bert" <bertcord@.gmail.com> wrote in message
news:1107580908.417955.239800@.g14g2000cwa.googlegroups.com...
>>Since you said this is going to be an OLTP you should be doing more
> seeks
>>than scans.
> Still lots of scnas... I guess I woudl call this a hybrid database.
> Ever 24 hours about 30-50 millions rows are loaded. Most queries are
> scanning this data.
>>You are spending a lot of money on drives so make sure you give the
> memory
>>it's due as well.
> We are starting with 8GB...hopefully this is enough.
>>Have you considered using 64 bit at all?
> I would love to ;)...heck we are still running windows 2000... Other
> reasons I am putting so much effort into measuring performance is so I
> have a baseline to compare to. Once I get this server set up I think I
> will finally have some time to start my WIn2003 and Yukon testing. I
> finished my .Net app today...I call it the DBJammer. Very simple for
> now but it creates two thread pools...one pool runs bulk inserts 2
> threads at A time and the other pool fires of queries against the data
> about 50 threads at a time. Hopefully I can use this to help get some
> good metrics. I have heard that an upgrade to windows 2003 gives a
> measurable performance gain as well.
>|||I agree... unfortunatley I am only the DBA..And it's not my decision.
I can't just say hey lets use windows2003 because it's better.
However I am going to run a set of tests on identical hardware, and
then I can say hey lets use windows 2003 because in these test it
performned this much faster. I think it is kind of crazy to spend all
of that money on hardware and use windows 2000.
Bert

proportional fill using multiple files

Wednesday, March 28, 2012

Proportional fill

All,

SQL Server uses a proportional fill method to add data to file groups where
a file group has multiple files. In general this is a good thing.
Unfortunately, the method appears to get switched off when new file(s) is
added. Other than exporting the data out of the filegroup, recreating the
filegroup and putting the data back in, is there a way to respread the
existing data back out and switching the proportional fill method back on?

Thanks,
DannyAs far as I know, there's no way to influence where MSSQL places data
within a filegroup. I'm not sure what you mean by "switched off" - if
you can give more details of what you're seeing, and what problem it
causes, then someone may have a suggestion.

Simon|||You can not turn this behavior off. I think what you mean is that when you
add a file to the filegroup the data is not re-balanced to evenly distribute
the data across all files including the new one. This is the way the system
is designed. You would have to force it by rebuilding indexes, but this
introduces a space requirement and a period in which the table is offline
during the rebuild.

GertD@.SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.

"Danny" <someone@.nowhere.com> wrote in message
news:9dRke.1781$5T2.877@.trnddc01...
> All,
> SQL Server uses a proportional fill method to add data to file groups
> where a file group has multiple files. In general this is a good thing.
> Unfortunately, the method appears to get switched off when new file(s) is
> added. Other than exporting the data out of the filegroup, recreating the
> filegroup and putting the data back in, is there a way to respread the
> existing data back out and switching the proportional fill method back on?
> Thanks,
> Danny

Property Promotion with multi-level XML data type

How would you extract data from an XML datatype column when it has multiple levels? I've done this with single levels using CROSS APPLY and the nodes method, but can't seem to grab data from the intermediate levels.

Example:

<Level2>xyz</Level2>

<Level2>xyz</Level2>

<Level3>abc</Level3>

<Level3>abc</Level3>

<Level3>abc</Level3>

<Level2>xyz</Level2>

<Level2>xyz</Level2>

</Level1>

For the root level, I use the xml.value() function, and for the details I use the cross apply xml.nodes() function typically, but if I use the xpath in the xml.nodes, I have to use the path to the lowest level (level3) to grab those values, but can't seem to grab the changing values at the intermediate levels (level2).

Would this involve multiple cross-apply instances?

I don't understand your example, why are those Level3 elements indented further to the right than the Level2 elements? They are both children of the root element Level1.

And it is not obvious what you want to extract.

|||

Sorry if this wasn't clear. The XML is supposed to represent a multiple-level heirarchy and the indentation indicates a parent-child relationship.

So level 1 can be Order, for example. At this level there can be several elements that define the Order (ID, Cust #, etc). Level 2 would be Order Type, like Internal, External, Global, Domestic (each order always has these 4 types associated with it). Level 3 would be details relevant to that order detail item, like part #, quantity, etc. (each Order has 4 Order Types, of which have multiple line-items within each order type).

So I need to return a table of data based on this single order. The results returned would have these fields:

Order ID (repeated for every order detail)

Cust # (repeated for every order detail)

OrderType (repeated for every order type/order detail)

Part # (unique per order detail/type)

Qty (unique per order detail/type)

Analogous to joining three relational tables (Order details -> Order Type -> Order) and getting the combined results of all three.

In SQL xquery, I use the .value function to get the Order ID and Cust# because they are at the root level of the XML field. I use the CROSS APPLY .nodes method to get to the lowest level of detail (Part# and Qty) and this produces the correct data. But for the intermediate level (Order Type) I can't seem to get to it.

If it still isn't clear, I'll send some actual XML.

Thanks

Kory

|||

Consider posting the XML and the query you have, then we can work from there to improve it.

|||

A coworker of mine helped me to figure this out:

I was doing this:

Before

With Namespaces(....)
select
t.EventDateTime
,t.OrderId

,ref.value('(//gns:OrderType/text())[1]','varchar(max)') OrderType
,ref.value('(ns:Product/text())[1]','varchar(max)') Product
,ref.value('(ns:Qty/text())[1]','varchar(max)') Qty
FROM
Orders t
CROSS APPLY
xmlfld.nodes ('//ns:OrderDetailItem') AS R(ref)

And we changed it to this:

After

With Namespaces(....)
select
t.EventDateTime
,t.OrderId

,ref.value('(http://gns:OrderType/text())[1]','varchar(max)') OrderType

So the only change was to the xpath from //gns Surprise rderType to http://gnsrderType

I really don't understand why this worked, but the first way just promoted the first occurance of the value, but the second method promoted the value when it changed.

-Kory

Monday, March 26, 2012

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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

Friday, March 30, 2012

Pros and cons of having multiple DBMS in the organization

Pros and cons of having multiple DBMS in the organization

proportional fill using multiple files

proportional fill using multiple files

proportional fill using multiple files

Wednesday, March 28, 2012

Proportional fill

Property Promotion with multi-level XML data type

Monday, March 26, 2012

Properly connecting to multiple instancesof SQL servers

Program Connection

Blog Archive

About Me