Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Unable to connect to a production sql server 2000 database

 
   Database Help (Home) -> Connect RSS
Next:  Unable to connect to a production sql server 2000..  
Author Message
wendyelizabeth

External


Since: Dec 27, 2004
Posts: 7



(Msg. 1) Posted: Mon Feb 14, 2005 8:37 pm
Post subject: Unable to connect to a production sql server 2000 database
Archived from groups: microsoft>public>sqlserver>connect (more info?)

I can not connect to the production SQL SERVER 2000 database using the
Enterprise Manager or the Query Analyzer on my work station.

I am getting the error,
"A connection could not be established to "". Reason: SQL Sserver does not
exist or access denied. ConnectionOpen(Connect(())..

This problem has occurred since the production SQL Server has moved to a
different ip address.

I have already right clicked on the icon for the production SQL Server to
try to change the registration properties. However, I do not see anything
that refers to ip addresses.

It would seem like I would use the "register SQL Server Wizard" to setup a
new connection but it does not seem to have the options I need.

Thus would you let me know what I need to do to setup this connection to the
production sql server has been changed to?

Note the following 2 items:

1. When I started at this small company, they put me at a workstation that
already had access to SQL Server already setup.
2. When I used SQL server before, I used windows authenication mode.

Thanks for your assistance.

 >> Stay informed about: Unable to connect to a production sql server 2000 database 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SBS 2003 and SQL 2000 unable to connect via internet - Hi, I have been reading everything I can in the Knowledge base and here about connection problems and am still unable to resolve my problem In the connection string I use the IP address for the SQL Server and it works fine when I'm connected to the..

Cannot connect to local sql server 2000 from VB.NET on pc .. - Hi I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC. When I run the following VB.NET code: Protected Const SQL_CONNECTION_STRING As String = _ "Server=localhost;" & _ "DataBase=Northwind;" &...

Sql server 2000 database connection problem -

So, how does it connect ?? - Hi , How does sql server client connect to SQL Server. Is there a sql.ini for sql server. If i add a alias entry in Client network utility where does it store the info. Thanks Neeraj

IIS 6 and Windows Authentication to SQL Server 2000 - I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server...
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]