newbie question

I am sorry if this question has been posted before, but a search in this
newsgroup has not solved the problem at hand:
I have installed MSDE on a windows xp pro machine with IIS already running.
Later I set up the MS Web data administrator (WDA)
However, it is impossble to log in via WDA.
As username I have tried "sa", my initials, my windows user name and
computername/windowsusername
As pw I have tried the strong pw that I used when making the installation
and leaving the pw field in blank.
As server I have tried "MSSQLSERVER", "Localhost" and my computer name.
Nothing works.
The funny thing is that MS Web Matrix can access MSDE without any problems
(which means that MSDE has been correctly installed, I suppose)
Any suggestions will be greatly appreciated.
Thanks
TB
Servername is "." or (local) or the Name of Your Computer, try this.
HTH, Jens Smeyer
http://www.sqlserver2005.de
"TB" <tbpostbox-googlegroups@.yahoo.com> schrieb im Newsbeitrag
news:O8PCyWbQFHA.4028@.tk2msftngp13.phx.gbl...
>I am sorry if this question has been posted before, but a search in this
>newsgroup has not solved the problem at hand:
> I have installed MSDE on a windows xp pro machine with IIS already
> running.
> Later I set up the MS Web data administrator (WDA)
> However, it is impossble to log in via WDA.
> As username I have tried "sa", my initials, my windows user name and
> computername/windowsusername
> As pw I have tried the strong pw that I used when making the installation
> and leaving the pw field in blank.
> As server I have tried "MSSQLSERVER", "Localhost" and my computer name.
> Nothing works.
> The funny thing is that MS Web Matrix can access MSDE without any problems
> (which means that MSDE has been correctly installed, I suppose)
> Any suggestions will be greatly appreciated.
> Thanks
> TB
>
|||When I open the SQL Server Service Manager, the server name is seems to be
the same as my computer name.
When I open the the log file created during the MSDE installation, I find
two entries which I don't know whether are relevant:
"Property(C): LogonUser = Trym"
"Property(C): USERNAME = tb"
Trym is my windows user name.
But I still can't seem to log in.
Is it possible to check what credentials MS Web Matrix uses to log in?
Thanks again.
TB
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OdfcmabQFHA.924@.TK2MSFTNGP14.phx.gbl...
> Servername is "." or (local) or the Name of Your Computer, try this.
> HTH, Jens Smeyer
> --
> http://www.sqlserver2005.de
> --
> "TB" <tbpostbox-googlegroups@.yahoo.com> schrieb im Newsbeitrag
> news:O8PCyWbQFHA.4028@.tk2msftngp13.phx.gbl...
>
|||hi TB,
TB wrote:
> When I open the SQL Server Service Manager, the server name is seems
> to be the same as my computer name.
> When I open the the log file created during the MSDE installation, I
> find two entries which I don't know whether are relevant:
> "Property(C): LogonUser = Trym"
> "Property(C): USERNAME = tb"
> Trym is my windows user name.
> But I still can't seem to log in.
> Is it possible to check what credentials MS Web Matrix uses to log in?
please verify your MSDE instance accepts SQL Server (standard) authenticated
connections verifying the Windows registry is set as following..
(named instance)
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
LoginMode=2
(default instance)
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hey, that worked: I changed loginMode from 1 to 2, and now I can log using
sa as the username via WDA.
However, another thing happened. After changing the above value, I rebooted
and now the SQL Server Service Manager is no longer visible in the system
tray. But the the database is clearly running (as I can log in from WDA).
Any suggestions?
Thanks again
TB
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3ca3suF6e6b6tU1@.individual.net...
> hi TB,
> TB wrote:
> please verify your MSDE instance accepts SQL Server (standard)
> authenticated connections verifying the Windows registry is set as
> following..
> (named instance)
> HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
> LoginMode=2
> (default instance)
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi TB,
TB wrote:
> Hey, that worked: I changed loginMode from 1 to 2, and now I can log
> using sa as the username via WDA.
> However, another thing happened. After changing the above value, I
> rebooted and now the SQL Server Service Manager is no longer visible
> in the system tray. But the the database is clearly running (as I can
> log in from WDA). Any suggestions?
>
please verify your autostart folder includes a link to service manager... if
not, please create a link to your service manager adding a final "/n" , like
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Done. Everything is OK now. Molto grazie.
TB
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3cacjaF6knavmU1@.individual.net...
> hi TB,
> TB wrote:
> please verify your autostart folder includes a link to service manager...
> if not, please create a link to your service manager adding a final "/n" ,
> like
> "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql