Ruffone
asked on
User does not have permission to perform this action.
I have SQLExpress 2008 installed on my local machine running XP Pro SP 3. I am loged in as Administrator. I am able to work with Visual Studio no problem. I am able to connect to the local instance of SQLExpress with SQL Managemant Studio but that is all that I could do. Anything else I try to do I get the error "User does not have permission to perform this action." Could anyone help me out on this
EXEC sp_grantlogin '(local)\[Administrator]'
Msg 15247, Level 16, State 1, Procedure sp_grantlogin, Line 13
User does not have permission to perform this action.
Thanks
EXEC sp_grantlogin '(local)\[Administrator]'
Msg 15247, Level 16, State 1, Procedure sp_grantlogin, Line 13
User does not have permission to perform this action.
Thanks
bull_rider
You are connecting with what user credentials to SQL Expres Management Studio? Try connecting to it through windows authentication and then try.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your response bull_rider
I am loged in as the local administrator of the maching. This is what have me so puzzled. This is literally what I type in and what I got back. I am loged into the machine "HYMAN" as "Administrator". Administrator is the name of the administrator account. It is the only account on the system. I use it to do everything on the system. I am very pissed that SQLExpress cannot see that.
C:\ >SQLCMD.exe -S HYMAN\SQLExpress -E
1>EXEC sp_grantlogin '[HYMAN]\[Administrator]'
2>GO
Msg 15247, Level 16, State 1, Server HYMAN\SQLEXPRESS, Procedure sp_grantlogin,
Line 13
User does not have permission to perform this action.
I am loged in as the local administrator of the maching. This is what have me so puzzled. This is literally what I type in and what I got back. I am loged into the machine "HYMAN" as "Administrator". Administrator is the name of the administrator account. It is the only account on the system. I use it to do everything on the system. I am very pissed that SQLExpress cannot see that.
C:\ >SQLCMD.exe -S HYMAN\SQLExpress -E
1>EXEC sp_grantlogin '[HYMAN]\[Administrator]'
2>GO
Msg 15247, Level 16, State 1, Server HYMAN\SQLEXPRESS, Procedure sp_grantlogin,
Line 13
User does not have permission to perform this action.
ASKER
when I try to type in the command you send I get this
C:\>osql -E
[SQL Server Native Client 10.0]Named Pipes Provider: Could not open a
connection to SQL Server [2].
[SQL Server Native Client 10.0]Login timeout expired
[SQL Server Native Client 10.0]A network-related or instance-specific error
has occurred while establishing a connection to SQL Server. Server is not
found or not accessible. Check if instance name is correct and if SQL Server
is configured to allow remote connections. For more information see SQL Server
Books Online.
C:\>osql -E
[SQL Server Native Client 10.0]Named Pipes Provider: Could not open a
connection to SQL Server [2].
[SQL Server Native Client 10.0]Login timeout expired
[SQL Server Native Client 10.0]A network-related or instance-specific error
has occurred while establishing a connection to SQL Server. Server is not
found or not accessible. Check if instance name is correct and if SQL Server
is configured to allow remote connections. For more information see SQL Server
Books Online.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then you can do one more thing, can you enable the Named Pipes in Sql Server surface area configuration and allow the remote connections as well there?
ASKER
I do not understand what is going on why I can't login with Management Studio but I found that I could work quite successfully in Visual Studio using the database diagram. All I ever wanted was to be able to do my work. So I am happy. Thank you guys for responding when I was pulling my hair out