Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-06-17
7
Medium Priority
?
330 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 16

Accepted Solution

by:
Surendra Nath earned 2000 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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

718 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