Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server Connection problems

Posted on 2005-05-03
5
Medium Priority
?
419 Views
Last Modified: 2008-02-26
First, thanks for taking time to help with this.

System:

- Relatively new Dell 2850 Server - RAID 5
- MS Small Business Server 2003 Premium (has SQL Server Standard with it)
- Accessing server remotely (behind firewall) using MS Remote Desktop mmc
- No SQL server database has been created - we're just starting out getting it setup

Problem:

I have had problems connecting locally (while 'remoting') to the default database.  At one point I was able to successfully connect and stay connected.  I then went into the properties of the default database from the Enterprise Manager and tried changing the authentication mode from Windows Only to Mixed Mode.  After I made the change, I clicked OK and got the following error after a few seconds:

A connection could not be established to (Local)
Reason: Invalid Connection.
ConnectionOpen(Invalid Instance())..
Please verify SQL Server is running and check your SQL Server registration properties
(by right-clicking on the (Local) node) and try again.

I performed the recommended action by the error message and set the registration properties as follows:

(Local) node registration properties are:
"Use SQL Server Authentication" is selected (I tried changing back to "Use Windows Authentication" and get the same error as above)

Under the "Options" section ...
- Group selected is - SQL Server Group (created by installation)
- Display SQL server state in console is checked
- Show system databases and system objects is checked
- Automatically start SQL Server when connecting is checked

At this point, everything I do to connect or change the database's properties results in the error message above.

Worth mentioning ... when I had the connection working, I tried to upsize an Access database to the SQL Server.  I tried doing that from a computer that was logged onto the server but using an account that is not a member of the domain (basically in Workgroup mode).  When the Upsizing Wizard tried connecting to the database, I got the same error on the machine I was upsizing from.  That's why I was changing to Mixed Mode.

We do need to get this going ASAP as this is a critical project.

Thanks for your help!

Arno
0
Comment
Question by:arnorite
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

by:andrewbleakley
ID: 13922441
Have you verified that SQL Server is running ?
Check the Service Applet (Start -> Programs -> Administrative Tools -> Services)
MSSQLSERVER. If it is running, restart the service.
Go back to Enterprise Manager and remove the registration, then re-register the server
0
 

Author Comment

by:arnorite
ID: 13922565
Yep, it's running and has been restarted about 153 times. :)

As for the re-register issue, I thought I did that when I got the error I described above.  If it's what you're talking about, then I just keep getting the same error.  If you're talking about something different, can you please give me the details of what you mean?

Thanks
0
 
LVL 11

Accepted Solution

by:
andrewbleakley earned 2000 total points
ID: 13922630
In client network utilities enabled Named Pipes as well as tcp/ip - move named pies to the top of the list. then try again.
Can you connect using Query Analyser ?
What value do you have under the Regsitry key
For a Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
For a Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\LoginMode
0
 

Author Comment

by:arnorite
ID: 13939805
OK, I'm back!  Andrew, thanks so much for your help!  It turned out that the named pipes wasn't being selected or wasn't the first in the list.  Everything works now!

Arno
0
 
LVL 11

Expert Comment

by:andrewbleakley
ID: 13939829
Sweet as mate, glad your sorted. Now get back to work :0)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question