|
|
You're in the
sql server msde
group:Need help on using Web Data Administrator
sql server msde:
using the command: setup sapwd="fruit" DISABLENETWORKPROTOCOLS=0 Then I installed the Web Data Administrator. After invoking the SQL Web Data Administrator app, the "Desired Port" is 80 and the "Cassini Personal Web Server" is selected. On clicking [Start] button, the IE starts and when I enter Username: sa Password: fruit Server: (local) The Authentication method: "Windows Integrated". The browser tells me back "Username is formatted incorrectly. Please use computername\username" Next I go to "System Properties" -> "Computer Name" tab on my XP and find the "Full computer name" to be TUNDRA (all in caps) So I again try as follows: Username: TUNDRA\sa Password: fruit Server: (local) The Authentication method: "Windows Integrated". Now the browser tells me "Invalid username and/or password, or server does not exist.". Could someone tell me what am I missing here...
Are you sure MSDE is installed as a base instance? Is it possible it's a
named instance? See if there are any services named MSSQL$something instead of just MSSQL ... -- http://www.aspfaq.com/ (Reverse address to reply.) [quoted text, click to view] "Bill Davidson" <carletoncourses@yahoo.ca> wrote in message news:c19ba23a.0410311525.2e8d8159@posting.google.com... > I installed the MSDE 2000 Release A on XP (Home ed.) > using the command: setup sapwd="fruit" DISABLENETWORKPROTOCOLS=0 > Then I installed the Web Data Administrator. > > After invoking the SQL Web Data Administrator app, > the "Desired Port" is 80 > and the "Cassini Personal Web Server" is selected. > > On clicking [Start] button, the IE starts and > when I enter > Username: sa > Password: fruit > Server: (local) > The Authentication method: "Windows Integrated". > > The browser tells me back > "Username is formatted incorrectly. Please use computername\username" > > Next I go to "System Properties" -> "Computer Name" tab on my XP > and find the "Full computer name" to be TUNDRA (all in caps) > So I again try as follows: > > Username: TUNDRA\sa > Password: fruit > Server: (local) > The Authentication method: "Windows Integrated". > > Now the browser tells me > "Invalid username and/or password, or server does not exist.". > > Could someone tell me what am I missing here... > > Bill
question...
* how can I find out if MSDE got installed as a base or named instance... In my XP (Home ed.) -> "Administratove Tools" -> "Services" window, I find the two entries name: MSSQLSERVER status: started name: MSSqlServerADHelper status: manual [quoted text, click to view] "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:<uXK6cb6vEHA.1984@TK2MSFTNGP14.phx.gbl>...
> Are you sure MSDE is installed as a base instance? Is it possible it's a > named instance? See if there are any services named MSSQL$something instead > of just MSSQL ... > > -- > http://www.aspfaq.com/ > (Reverse address to reply.) > > > > > "Bill Davidson" <carletoncourses@yahoo.ca> wrote in message > news:c19ba23a.0410311525.2e8d8159@posting.google.com... > > I installed the MSDE 2000 Release A on XP (Home ed.) > > using the command: setup sapwd="fruit" DISABLENETWORKPROTOCOLS=0 > > Then I installed the Web Data Administrator. > > > > After invoking the SQL Web Data Administrator app, > > the "Desired Port" is 80 > > and the "Cassini Personal Web Server" is selected. > > > > On clicking [Start] button, the IE starts and > > when I enter > > Username: sa > > Password: fruit > > Server: (local) > > The Authentication method: "Windows Integrated". > > > > The browser tells me back > > "Username is formatted incorrectly. Please use computername\username" > > > > Next I go to "System Properties" -> "Computer Name" tab on my XP > > and find the "Full computer name" to be TUNDRA (all in caps) > > So I again try as follows: > > > > Username: TUNDRA\sa > > Password: fruit > > Server: (local) > > The Authentication method: "Windows Integrated". > > > > Now the browser tells me > > "Invalid username and/or password, or server does not exist.". > > > > Could someone tell me what am I missing here... > >
Hi Bill,
In addition to what Aaron mentioned, the "sa" user is not part of "Windows Authentication". It is using "Mixed Mode" or "SQL Server Authentication". HTH, -- Greg Low [MVP] MSDE Manager SQL Tools www.whitebearconsulting.com [quoted text, click to view] "Bill Davidson" <carletoncourses@yahoo.ca> wrote in message news:c19ba23a.0410311525.2e8d8159@posting.google.com... >I installed the MSDE 2000 Release A on XP (Home ed.) > using the command: setup sapwd="fruit" DISABLENETWORKPROTOCOLS=0 > Then I installed the Web Data Administrator. > > After invoking the SQL Web Data Administrator app, > the "Desired Port" is 80 > and the "Cassini Personal Web Server" is selected. > > On clicking [Start] button, the IE starts and > when I enter > Username: sa > Password: fruit > Server: (local) > The Authentication method: "Windows Integrated". > > The browser tells me back > "Username is formatted incorrectly. Please use computername\username" > > Next I go to "System Properties" -> "Computer Name" tab on my XP > and find the "Full computer name" to be TUNDRA (all in caps) > So I again try as follows: > > Username: TUNDRA\sa > Password: fruit > Server: (local) > The Authentication method: "Windows Integrated". > > Now the browser tells me > "Invalid username and/or password, or server does not exist.". > > Could someone tell me what am I missing here... > > Bill
Hi Bill,
That's a default instance. Named instances would have service names like MSSQLSERVER$instancename HTH, -- Greg Low [MVP] MSDE Manager SQL Tools www.whitebearconsulting.com [quoted text, click to view] "Bill Davidson" <carletoncourses@yahoo.ca> wrote in message news:c19ba23a.0411010807.66cf3ef9@posting.google.com... > question... > * how can I find out if MSDE got installed as a base or named instance... > > In my XP (Home ed.) -> "Administratove Tools" -> "Services" window, > I find the two entries > name: MSSQLSERVER status: started > name: MSSqlServerADHelper status: manual > > > > "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message > news:<uXK6cb6vEHA.1984@TK2MSFTNGP14.phx.gbl>... >> Are you sure MSDE is installed as a base instance? Is it possible it's a >> named instance? See if there are any services named MSSQL$something >> instead >> of just MSSQL ... >> >> -- >> http://www.aspfaq.com/ >> (Reverse address to reply.) >> >> >> >> >> "Bill Davidson" <carletoncourses@yahoo.ca> wrote in message >> news:c19ba23a.0410311525.2e8d8159@posting.google.com... >> > I installed the MSDE 2000 Release A on XP (Home ed.) >> > using the command: setup sapwd="fruit" DISABLENETWORKPROTOCOLS=0 >> > Then I installed the Web Data Administrator. >> > >> > After invoking the SQL Web Data Administrator app, >> > the "Desired Port" is 80 >> > and the "Cassini Personal Web Server" is selected. >> > >> > On clicking [Start] button, the IE starts and >> > when I enter >> > Username: sa >> > Password: fruit >> > Server: (local) >> > The Authentication method: "Windows Integrated". >> > >> > The browser tells me back >> > "Username is formatted incorrectly. Please use computername\username" >> > >> > Next I go to "System Properties" -> "Computer Name" tab on my XP >> > and find the "Full computer name" to be TUNDRA (all in caps) >> > So I again try as follows: >> > >> > Username: TUNDRA\sa >> > Password: fruit >> > Server: (local) >> > The Authentication method: "Windows Integrated". >> > >> > Now the browser tells me >> > "Invalid username and/or password, or server does not exist.". >> > >> > Could someone tell me what am I missing here... >> > >> > Bill
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |