Cannot open the local NT group in the SQL Server Group

Hello,
I logged in as administrator, and tried to open the local
NT SQL Server and the message appears:
"A connection could not be established to (local).
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect()).
Please verify SQL Server is running and check your SQL
Server Registration properties (by right-clicking on the
(local node) and try again."
I cannot access the registration properties.
I also checked event viewer and found the following error
message:
"There are multiple accounts with name
MSSQLSvc/mpserver01.martinousproduce.local:1433 of type
10. "
Any ideas on the problem? I restarted the SQL Server but
still unable to connect.
Thanks,
JoeDo you have more than 1 instance of SQL server installed?
Perhaps they are both trying to use the same IP port
number of 1433. Go to your NT services and see how many
instance you have of SQL. Try and start and connect to one
of them and then see if you have a clash of IP port
numbers.
If that isn't the case check that the SQL service is
running (by going to your NT services). Then, check
your "server network utility" from the program menu and if
TCP/IP is there take it out and put in named pipes. If
TCP/IP isn't there, then put it in. Remember you could
affect how people connect to the SQL server (i.e. is it in
production?) so take care when making your changes and
write them down so you don't forget how to undo them.
Hope this helps.
-J
p.s. just one more thought...do you have a name conflict
on the network? If so, it is possible that this SQL
server's IP stack did not initialize and therefore the SQL
services won't start.
>--Original Message--
>Hello,
>I logged in as administrator, and tried to open the local
>NT SQL Server and the message appears:
>"A connection could not be established to (local).
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect()).
>Please verify SQL Server is running and check your SQL
>Server Registration properties (by right-clicking on the
>(local node) and try again."
>I cannot access the registration properties.
>I also checked event viewer and found the following error
>message:
>"There are multiple accounts with name
>MSSQLSvc/mpserver01.martinousproduce.local:1433 of type
>10. "
>Any ideas on the problem? I restarted the SQL Server but
>still unable to connect.
>Thanks,
>Joe
>.
>

Cannot Login with Web Data Administrator

With Cassini web server, the hour glass stays on after I type in "sa" and password with SQL Login. Does anyone know how to resolve the issue?

With IIS, it simply displays the content of default.aspx as text. Are there some settings need to be changed?

My system is: Windows XP Professional with SP2.

Any help is appreciated.

Chinghuh? let's be more descriptive.|||Kay,

After I installed the SQL Web Data Administrator on my computer, I started it with IIS selected. It comes back displaying the content of http://localhost/webadmin/default.aspx in IE.

I then change the selection to Cassini Personal Web Server and start. The desired port is changed to 111. The logon page displays in IE. I type in "sa" in Username field and myPassword in Password field. The server field is (local) and the Authentication Method is "SQL Login". After I click the Login button, the hour glass stays.

Do you know how to solve this problem? Thank you for any help.

Ching|||Is your database installed and running? Unfortunately, I don't use Cassini, so I don't know what's wrong.

Cannot find module in web data administrator

I just downloaded the web data administrator from MSDN and after entering my credential, I get this error:

Specified module cannot be found
at SqlAdmin.SqlServer.Connect()
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()

The only page I can see is the Import page, the database and the export get the same error.
It's a fresh install, anyone know something I need to do to get a correct install ?Since I had not yet downloaded and installed the Web Data Administrator, I went just now and installed it from Microsoftlink

I just clicked on Download, chose "Open" and just left whatever defaults there might have been. I went into SQL Server and changed the authentication mode to mixed. Then I went to http://localhost/sqlwebadmin/default.aspx and logged in with my sa login and password. It all worked like a charm.

Not sure what help any of that is...

Terri|||I tried doing another clean install, but I get the same problem.

I can login just fine, but after leaving default.aspx, I get the error in the 2 other pages.

Without better error description I fear I won't be able to find the bug in all this code, more so if it work on other machines.

Here is the code of the Connect Method from where the error seem to be coming:

 dmoServer = (NativeMethods.ISqlServer)new NativeMethods.SqlServer();
 dmoServer.Connect(Name, Username, Password);

I have no idea what's this NativeMethods thing is coming from. I'm using MSDE, could that be the problem ?