Why sql server didn't get administrator rights which was installed during application setup process?

Question

Hello I am building a windows based application. I am generating setup with install shield in visual studio. Now I am adding prerequisites as .net framework 4 client profile and sql server 2008 express. and selecting option of Download prerequisites from the same location as my application.

Now when I am installing this app in client's system sql server also installed properly. But when I am running my app. it stopped working because sql server has no admin rights. What is the solution for it? What I should do that's why sql server have administrator rights. And my app works properly..

Thanks in advance.

Answer 1

Try upgrading your prerequisite to at least SQL Server 2008 R2.

SQL Server 2008R2/2012 installer supports /ADDCURRENTUSERASSQLADMIN parameter, set to true by default for Express Edition.

Answer 2

did you have administrator rights when you was installing the sql server? This might help you with the "standard sql server administrator": System Administrator (sa) Login

The password for the "sa" user depends on the selected login-mode during the installation. Dont worry - you dont have to reinstall your sql server.

You are able to change the authentication mode like that.

After you figured ou the administrator name and the password you should be able to login with your windows app by using the correct login values :)

Sincerly, Toby