using the osql command
-
I have a book which shows an example of using the osql command but when I try it, I get a message that the SQL Server does not exist or access is denied. The command I am entering is: osql -E Can anyone tell me how to grant access or find another way around this?
-
I have a book which shows an example of using the osql command but when I try it, I get a message that the SQL Server does not exist or access is denied. The command I am entering is: osql -E Can anyone tell me how to grant access or find another way around this?
Is your server set up for windows authentication or sql server authentication? If the latter, -E will fail. This will also fail if the server is not running... Absolute faith corrupts as absolutely as absolute power Eric Hoffer All that is necessary for the triumph of evil is that good men do nothing. Edmund Burke
-
Is your server set up for windows authentication or sql server authentication? If the latter, -E will fail. This will also fail if the server is not running... Absolute faith corrupts as absolutely as absolute power Eric Hoffer All that is necessary for the triumph of evil is that good men do nothing. Edmund Burke
The options are either both windows auth AND sql server auth at the same time, or only windows auth. So
osql -Eshould be available always. If it doesnt work, it might be that you're logged on to Windows using an account that has not been granted access to MS SQL Server. -
The options are either both windows auth AND sql server auth at the same time, or only windows auth. So
osql -Eshould be available always. If it doesnt work, it might be that you're logged on to Windows using an account that has not been granted access to MS SQL Server.When I installed the MSDE version of SQL Server, I did so with Windows authorisation. If I need to grant my account access to the SQL Server, could you tell me how to do this? When my computer starts, the Server is showing as running, and so I don't think this is the problem.
-
When I installed the MSDE version of SQL Server, I did so with Windows authorisation. If I need to grant my account access to the SQL Server, could you tell me how to do this? When my computer starts, the Server is showing as running, and so I don't think this is the problem.
In Enterprise Manager: Expand the server your trying to access, then expand the Security node and click on the Logins node under Security. Here you can create a new login with Windows Authentication. -a