Having installed SQLServer2005, Cannot log into

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Having installed SQLServer2005, Cannot log into

Author

Topic

pssheba
Yak Posting Veteran

95 Posts

Posted - 2012-10-28 : 07:14:40

SSMS
Hi everyone,
I have installed SQLServer2005. In the SSMS interface, at the "Server Name" I insert my server instance name, at "Login" I insert "sa" and the password for "sa".
I get an error message with the title: "cannot connect to home/server_name".
The error message says:
"An error has occurred while establishing connection to the server. When connecting to SQL server2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections (provider: named Pipes Provider , error: 40 - could not open a connection").
I turned to "SQL Server Surface Area Configuration" where I selected:
" Surface Area Configuration for Services and Connections" and among other services I realized that the Server service status was "stopped" so I clicked: "Start" only to get a new error message that says: "An Error occurred while performing this operation".
Any Idea what else is there I can do to log into the management server?
Thanks

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-10-28 : 11:51:41

You can't log in because the server service isn't running.
Have a look at the services and see why it isn't running. Hopefully it's something simple like the user doesn't have permission otherwise you might have to do a re-install.
Didn't you get an erro when you installed?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-29 : 03:25:28

What account are you usin for the SQL Services start? Is it a domain account ? Have you tried using the Local System account?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

pssheba
Yak Posting Veteran

95 Posts

Posted - 2012-10-29 : 08:53:29

quote:
Originally posted by jackv

What account are you usin for the SQL Services start? Is it a domain account ? Have you tried using the Local System account?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

I use System Administrator (sa) account. I tried both domain authentication and sql authentication.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-29 : 12:56:42

pssheba - I meant the the account for the Services. Type "services.msc" into the cmd line - find the service related to the SQL Server Instance - and see what account you are using to start up

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

pssheba
Yak Posting Veteran

95 Posts

Posted - 2012-11-06 : 07:11:57

quote:
Originally posted by jackv

pssheba - I meant the the account for the Services. Type "services.msc" into the cmd line - find the service related to the SQL Server Instance - and see what account you are using to start up

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

"Network service" ? This is what I find under "Log on as".
By the way, I'm late in responding because I reinstalled the server with default instance (MSSQLSERVER) and the server is aliv and kicking but........... I cannot restore my *.bak files that were backuped from another instance so what the heck...
Thanks

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-11-06 : 07:51:46

1) Is the other instance - a higher version than the one in which you are attempting the restore?
2) What error message?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

pssheba
Yak Posting Veteran

95 Posts

Posted - 2012-11-07 : 06:50:54

quote:
Originally posted by jackv

1) Is the other instance - a higher version than the one in which you are attempting the restore?
2) What error message?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Thanks for persisting Jack. I already gave up:-(
Both Servers are of the same installation disk which I possess.
This is the error message I get when I try to restore a *.bak file from my disk to the database:

quote:
restore failed for server 'HOME'. (microsoft.SqlServer.Smo)
Additional information
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All
members must be provided. (Microsoft.SqlServer.Smo)

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-11-07 : 08:36:56

How did you backup the file initially - was it : BACKUP DATABASE mydb to DISK = 'my_disk_destination' . ?
It looks like the backup of the database wrote its data to two files.
Try the backup again with similar command to above and attempt the RESTORE , do you still get the same error message?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

pssheba
Yak Posting Veteran

95 Posts

Posted - 2012-11-08 : 09:21:47

quote:
Originally posted by jackv

How did you backup the file initially - was it : BACKUP DATABASE mydb to DISK = 'my_disk_destination' . ?
It looks like the backup of the database wrote its data to two files.
Try the backup again with similar command to above and attempt the RESTORE , do you still get the same error message?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Hi Jackv,
Thanks for your help.
This is how I backup:
1. From right click menu on "Diary" database I select: "Tasks" and then "Backup";
2. At the "Back Up Database - diary" window I select:
a. "diary" at the "Database" scrolling list;
b. Radio button "Database" at "Backup component" area;
c. "Disk" radion button at "Back up to" area and then I press the "Add" button for a location on the disk;
3. I select the "option" menu item from "Select a page" area and I select: "Back up to the existing media" set and "overwrite all existing backup sets";
OK, and I get a message that says: "The backup of database 'diary' completed successfully".
I try (unseccessfully !) to restore that database as follows:
1. From right click menu on "Diary" database I select: "Tasks" and then "restore" and "Database";
2. In the "Restore Database - diary" window I select "diary" from the "Destination for restore" scrolling list;
3. I select the "From device" radio button and in the "Specify Backup" window I click "Add" and from its' location on the disk I select the "diary.bak" file I backuped before;
4. I select "Options" menu item and I select "Overwrite the existing database" radio button;
5. in the "Original file name" list I see 2 files:
a. "diary-------c:\program files\Microsoft SQL Server\MSSQL 3\ MSSQL\DATA\diary.mdf"
b. "diary-------c:\program files\Microsoft SQL Server\MSSQL 3\ MSSQL\DATA\diary_log.ldf"
6. For the first item I select the location where I backed up diary.bak on disk (d:\diary\test.bak) and I leave the second item as is;
When I press OK I get the error message I cited before.
I really appreciate your patience and willingness to help me with a problem I thought I might forget about my old backups.
Thanks a lot !

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources