MS SQL Server - SQL Servers 2000 and 2005

Author

SQL Servers 2000 and 2005

ngorbunov via SQLMonster.com

2006-10-24, 6:28 pm

Our network guy first installed 2005 on our server. I created a database, we
had some sort of issues and so decided to install 2000. I removed the db I
created on 2005 and restored it on 2000 instead.

Here's my problem....When I log in to query analyzer(sql 2000) using my
windows auth, I get a list of database that are on the 2005 server, not 2000.

I think 2005 is set as my default server. How can I change it to be 2000?

Any help is greatly appreciated.

Thanks,
Ninel

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200609/1

Arnie Rowland

2006-10-24, 6:28 pm

If the SQL 2005 server was NOT uninstalled, then when SQL 2000 was
installed, it used a named instance.

Instead of ServerName, it will be ServerName\InstanceN
ame.

In QA, in the [Connect to SQL Server] box, click on the ellipsis and select
the server from the list.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"ngorbunov via webservertalk.com" <u9125@uwe> wrote in message
news:664892dfdcdb6@u
we...
> Our network guy first installed 2005 on our server. I created a database,
> we
> had some sort of issues and so decided to install 2000. I removed the db I
> created on 2005 and restored it on 2000 instead.
>
> Here's my problem....When I log in to query analyzer(sql 2000) using my
> windows auth, I get a list of database that are on the 2005 server, not
> 2000.
>
>
> I think 2005 is set as my default server. How can I change it to be 2000?
>
> Any help is greatly appreciated.
>
> Thanks,
> Ninel
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200609/1
>

ngorbunov via SQLMonster.com

2006-10-24, 6:28 pm

The 2000 server is set up in enterprise manager as ITITPAIT04\SQL2K.

This is how I am trying to login with query analyzer. It is not working.
"SQL Server does not exist or access denied"

What now?

Arnie Rowland wrote:[color=darkred
]
>If the SQL 2005 server was NOT uninstalled, then when SQL 2000 was
>installed, it used a named instance.
>
>Instead of ServerName, it will be ServerName\InstanceN
ame.
>
>In QA, in the [Connect to SQL Server] box, click on the ellipsis and select
>the server from the list.
>
>[quoted text clipped - 11 lines]

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200609/1

Arnie Rowland

2006-10-24, 6:28 pm

Are you trying Windows Authentication or SQL Server Authentication?

You might try SQL Server Authentication, using username: sa with a blank
password.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"ngorbunov via webservertalk.com" <u9125@uwe> wrote in message
news:6649299af6f0e@u
we...
> The 2000 server is set up in enterprise manager as ITITPAIT04\SQL2K.
>
> This is how I am trying to login with query analyzer. It is not working.
> "SQL Server does not exist or access denied"
>
> What now?
>
> Arnie Rowland wrote:
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200609/1
>

ngorbunov via SQLMonster.com

2006-10-24, 6:28 pm

Ok...I created a login on the 2000 server called timecontroluser. When I use
remote desktop to logon to the server I connect to query analyzer like this:

SQL Server: ITITPAIT04\SQL2K
SQL Authentication:
Login: timecontroluser
Pass: timecontroluser

This works. I get logged in.

When I am not directly on the server, but using my local query analyzer to
logon doing the same as above, I get "SQL Server does not exist or Access is
denied"

ngorbunov wrote:[color=darkred
]
>The 2000 server is set up in enterprise manager as ITITPAIT04\SQL2K.
>
>This is how I am trying to login with query analyzer. It is not working.
>"SQL Server does not exist or access denied"
>
>What now?
>
>[quoted text clipped - 9 lines]

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200609/1

Uri Dimant

2006-10-24, 6:28 pm

Hi
Is it cluster ? Perhaps SQL Server is configured to listen to another port
than 1433.

"ngorbunov via webservertalk.com" <u9125@uwe> wrote in message
news:66495fc38a6ef@u
we...
> Ok...I created a login on the 2000 server called timecontroluser. When I
> use
> remote desktop to logon to the server I connect to query analyzer like
> this:
>
> SQL Server: ITITPAIT04\SQL2K
> SQL Authentication:
> Login: timecontroluser
> Pass: timecontroluser
>
> This works. I get logged in.
>
> When I am not directly on the server, but using my local query analyzer to
> logon doing the same as above, I get "SQL Server does not exist or Access
> is
> denied"
>
>
>
>
> ngorbunov wrote:
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200609/1
>

Sponsored Links