Apparently, the said MSDE only uses Windows authentication mode (which is
default installation setting). If you want to use SA account (bad idea for
generic SQL Server access) or use username/password pair of logging into SQL
Server/MSDE, you need to explicitly enable mixed security mode.
I've installed a program called Winfinance who saves it's data to
MSDE.
When i log on to the database with my credentials as a server
administrator i get access, however, when i try to log on as the "sa"
i get access denied.
Does anybody have a guess why i don't get access or a way that i can
get it?
Re: SA has no access ... If you are really getting an access denied message, it's more likely you just have the wrong SA password. ... default installation setting)....generic SQL Server access) or use username/password pair of logging into SQL ... (microsoft.public.sqlserver.msde)
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: 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)
Re: SA has no access ...generic SQL Server access) or use username/password pair of logging into SQL ... (microsoft.public.sqlserver.msde)
