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.
Hi,
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.
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?
Ortiza
Member
37 Points
92 Posts
Re: I don't know if I downloaded the correct version of SQL Server Express 2008
Feb 01, 2013 09:21 PM|LINK
http://www.rtssys.com/blog/archives/14.html
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.
wmec
Contributor
6195 Points
3214 Posts
Re: I don't know if I downloaded the correct version of SQL Server Express 2008
Feb 01, 2013 10:43 PM|LINK
Hi,
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.
HuaMin Chen
Ortiza
Member
37 Points
92 Posts
Re: I don't know if I downloaded the correct version of SQL Server Express 2008
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?
wmec
Contributor
6195 Points
3214 Posts
Re: I don't know if I downloaded the correct version of SQL Server Express 2008
Feb 02, 2013 03:11 AM|LINK
Hi,
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.
HuaMin Chen
Ortiza
Member
37 Points
92 Posts
Re: I don't know if I downloaded the correct version of SQL Server Express 2008
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.
wmec
Contributor
6195 Points
3214 Posts
Re: I don't know if I downloaded the correct version of SQL Server Express 2008
Feb 03, 2013 07:54 AM|LINK
Have you enabled sa account? Or can you login using Windows authentication?
HuaMin Chen