on 09-04-2013 7:34 PM
Hi,
I have a similar post here, but not the same. This is a doubt I have when trying to restore DB using a backup file (.BAK)
I have a new Windows 2008 R2 box, and have a .bak file, which is an online sql backup of another SAP system. I want to restore this backup to the new box, and build a new SAP system.
Here's what I have done, and is failing -
1) Installed SQL Server 2008 using SAP's DVD. It was a silent install. While installing, I selected the SQL instance as "default" which was SAP recommended.
2) I am going to the SQL Management studio now, so that I can restore the DB from the BKP file. How do I connect, and what do I connect to? I tried windows authentication. I am administrator on the system, and it don't let me in. I cannot use SU or SQL authentication as I don't have any other info from the install. How do I restore my backup to the system????
Thanks for all the help.
You should be able to connect using "localhost" and Windows authentication.
Check services "SQL Server (MSSQLSERVER)" and "SQL Server Agent (MSSQLSERVER). Both need to be running.
Make sure that your user is a part of the local Administrators group. I have had problems connecting with a domain admin account that was not explicitly made a member of the local group.
If this doesn't work, can you give us the exact error you get?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Susan.
I tried localhost and it don't work. To make it more clear, I haven't installed SAP on this system. So, I assume no databases are created. Still, would I be able to connect to the default and restore database from backup? What I am trying to do is to build a system using the db backup I have. Not sure if I am doing something wrong here.
Also note that I am in the administrator group and in the domain admins group.
please see error screen attached.
My user is Domain\User
Hi Jim
have look this link refer to that error code 18456 for authentication user & once try with change the host name from local to some other domain 7 then try
http://www.katieandemil.com/microsoft-sql-server-error-18456-login-failed-for-user
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.