Solved

Can't get MS SQL 2005 to connect to my local server

Posted on 2013-06-17
7
320 Views
Last Modified: 2013-06-18
My hard drive died, so I had it replaced.  The tech company reinstalled Windows 7 Professional, and I installed SQL 2005, 64 bit.  It connects to other servers, but it won't connect to my local server.  The typical, non-descript error: 18456.  I searched forums for answers.  I made sure IIS was started, I added port 1433.  I even uninstalled and reinstalled it to make sure I set it up to just use Windows Authentication.  Nothing changed.  

Various instructions talk about SQL Server Express, but I'm using Microsoft SQL Server Management Studio, so I don't know if that's a different program or what.  

There are many links to Microsoft or other forums...some times I don't understand what they're saying, other times, I can't figure out how to get to what they recommend.

Can anyone help?
0
Comment
Question by:StellaBob
  • 4
  • 3
7 Comments
 

Author Comment

by:StellaBob
ID: 39254758
One other thing...I'm not sure if I need other service packs or hot fixes.  I tried downloading one hotfix I found on another post, but it wouldn't install...talked about SQL Server Express Studio again and bombed out.
0
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39254783
I suggest you follow the below steps

1) Check if the instance of the SQL Server is the default instance or named instance.
      How to check SQL Server you installed is default instance or named instance
          Open Services by running the command Services.msc in the run window, Locate for SQL Server Service and see if it has (MSSQLSERVER) in parenthesis or something else... if it just has MSSQLSERVER then it is local instance or else it is named instance.

2) Now if you have local instance and if you are unable to login into the sql server... Then the problem might be with the windows authentication, ensure that you are using the same windows login that you are using when you are installing the sql server
      One point here, I even suggest you create mixed mode authentication, in the authentication tab, and add a SQL Server user while installing and ensure that this SQL Server user is added SQLADMIN role.

3) if the instance is a named instance, then most probably you might be giving the wrong server name, you have to give .\<instanceName>

Hope this helps
0
 

Author Comment

by:StellaBob
ID: 39254828
I just looked at the Services and it does read: SQL Server (MSSQLSERVER).  As for #2, when I installed, I didn't use any kind of login...I just selected Windows Authentication, so I'm not sure how to change that.

One thing to note...I was going through some other instructions I found.  it had me go back to the SQL Servicer Configuration Manager to make sure the built-in account of the local system is being used, but when I opened the Configuration Mgr, two items in the list read 32 bit.  SQL Server 2004 Network Configuration and SQL Native Client Configuration.  I believe I first installed the 32 bit version, then as I went through the disks, realized there was one for 64 bit and Itanium.  So I uninstalled it and reinstalled the 64 bit version.  Could this be the problem?
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39254868
it could be.
did the re-installing resolve the issue...
0
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 500 total points
ID: 39254875
if you are ok to re-install again then I suggest you to follow the below instructions in the website and re-install it again... he has given on how to set up the mixed mode authentication for sql server...

http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-quick-guide.aspx
0
 

Author Comment

by:StellaBob
ID: 39254991
Thanks...I'll try this and let you know.
0
 

Author Closing Comment

by:StellaBob
ID: 39257491
YOU'RE AWESOME!!!  The instructions were very helpful as I had just checked Windows Authentication versus the Mixed Mode.  Thank you, thank you, thank you!!!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now