Question

Hello every body.

I have a problem with SQL Server. I have two computers (XP and Vista) I am developing my project sometimes on XP and sometimes on the Vista one.

Everything was fine until when I started working on login part of website. The XP is totally fine but when I run my website on my Vista to see and test, this error show up:

So I did a little search and aparently this is what I should do to fix this problem:

sp_configure 'user instances enabled','1'

RECONFIGURE;

GO

I used this code in SQL server Express and pressed Execute, but this was the error:

Msg 15247, Level 16, State 1, Procedure sp_configure, Line 94
User does not have permission to perform this action.
Msg 5812, Level 14, State 1, Line 2
You do not have permission to run the RECONFIGURE statement.

Now I have no idea how to fix it any further.

I appreciate your help.

Thank you.

Try to login with admin or sa account which has admin prievelage on Sql Server ...

|||

You might try logging in as the Adminstrator on the XP machine before running your recongifuration script.

|||

Thank you very much, I tried it as Admin but still the same exact error is there.

Stiletto you said log in on XP as admin but my problem is not on XP its on Vista.

I actually tried the same thing before (I loged in as Admin) but now this is the second time and still the error is the same.

Do I need to uninstall the SQL server and install it back ? What do you think friends ?

|||

Check the permission with the sa or admin acount of sql provide it full permissions and try again ... uninstalling is not a solution i think so ..

|||

Do I need to attach my website's database before running that SQL code ?

And where do i have to check the permission ?

|||

Check the Permissions in the Sql Management Studio for the User ...

|||

Hi,

I am kind of new with this. Where am I suppose to do this (Checking user permissions). I mean which part of managment studio ?

What would generally cause this in the first place ? how come my XP is fine but Vista turned up to be like this ?

|||

I think you XP and Vista has different Sql Server installed. You need to goto open Sql Server Management Studio . Under the security node under the login check for the particular account. Click on the account you want to give permission .. check the server roles. You can enabled more roles.