Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 03, 2013 07:54 AM by wmec
Feb 01, 2013 09:21 PM|LINK
I used the above link to do what you suggested. I'm stuck on the part where it says to open SQL Server Management Studio. I don't have that in my Configuration Tools folder.
Feb 01, 2013 10:43 PM|LINK
Have you created the relevant database instance in the machine. Do you see all the relevant services of the instance have been started?
If even the instanace has not been created, there must be a problem with your setup. Then you can redo the setup with this "SQLEXPRADV_x64_ENU.exe" (or that x86 one). After the re-setup, you should be able to open SS management studio.
Feb 02, 2013 02:53 AM|LINK
I completed the setup. I am able to open SS management studio. I am now setting up the local database instance.
I'm using this link: http://www.rtssys.com/blog/archives/14.html.
I'm at the Setup User Account part. I'm at the New Login screen. These directions don't explain this part very well.
.......... Am I supposed to click Windows Authentification or SQL Server Authentification?
Then, the directions say Default database -> Your Database
............I have 6 choices.... master, model, msdb, ReportServer$SQLExpress, ReportServer$SQLExpressTempDB, and tempdb. Which one of these should I chose.
Next step is User Mapping Page -> Map to your db and grant db_owner role
............It doesn't tell you how to go about doing this. Do I click map to certificate? map to asymmetric key? map to credential?
Feb 02, 2013 03:11 AM|LINK
During the setup, you have the chance to set up one instance. Please now check what the relevant name is within Windows services.
You can choose Sql server authentication and then set up the password for sa login.
Feb 03, 2013 01:48 AM|LINK
If I already setup an instance during the setup, then why are you telling me to setup another instance?
I am following this link http://www.rtssys.com/blog/archives/14.html because you told me to setup a local database instance.
Plus, after the setup, I still have SQL Import/Export Wizard in my SQL Server R2 folder.
Feb 03, 2013 07:54 AM|LINK
Have you enabled sa account? Or can you login using Windows authentication?