Re: Microsoft SQL Server Management Studio

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Rogers,

Were you trying to run a script to create a user or were you using the
GUI?

Is the server in Windows Authentication mode or Mixed mode?

.

Relevant Pages

  • Re: Windows authentication mode
    ... Actually you need to change the connection string to select windows authentication and every thing is taken care for you by the OLEDB driver automatically. ... connection string that uses the windows authentication mode and does not require a user name or password to login. ... MY_DATABASE is a dummy name here which you must change to an existing database on your server, the same upplys for the MY_SQLServer it must be changed to an existing SQLServer. ...
    (borland.public.delphi.database.ado)
  • Re: SA has no access
    ... the said MSDE only uses Windows authentication mode (which is ... default installation setting). ... generic SQL Server access) or use username/password pair of logging into SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL 2008 remote Management Studio connection
    ... right-click the server name and then click Properties. ... is SQL Server and Windows Authentication mode selected? ... If the server was installed in Windows Authentication mode, and then changed to SQL Server and Windows Authentication mode then the sa account was disabled. ...
    (microsoft.public.sqlserver.connect)
  • Re: 2000 Developer Edition & Windows Advanced 2003 Server - options?
    ... Can I choose any server name I want or do I actually need to use the ... The current set up is now in Windows Authentication mode as you say. ... > Right-click the SQL Server Group node on the tree. ... all local administrators on a server are ...
    (microsoft.public.sqlserver.setup)
  • How to determine Authentication Mode?
    ... Given a server name, how can I tell if it's using Windows Authentication Mode ... Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm ...
    (microsoft.public.sqlserver.programming)