Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts

Wednesday, March 28, 2012

MSDE Setup -- Wheres the Server?

I am using VB.net to build ASP.net pages. I finally decided it was time to start using SQL server based code. So, I installed MSDE...or so I thought.

I have the server Icon in the bottom systray and it's green and seems to be running.

I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.

An in VB.net I see a master.dbo connection in Server Explorer.

But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer...the Create a New SQL database menu item is greyed out.

My concern is that my installation is not complete and/or I don't know how to locate and verify the server.

Any help would be appreciated. ThanksMSDN link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp to run thru the details.

Friday, March 23, 2012

MSDE Password

I have a MSDE database running with my sharepoint portal and now i want to customize the portal with some pages built in webmatrix, but i am getting a huge problem. i just don't know what he MSDE password is. how may i find it out, change it or even break it?well, if it's set up with default options, the machine's administrator account should be able to access it without needing the sa password.|||Hi Atrax,

thxs for the support. I've tryied that but didn't work. I type "osql -U sa" and set the password for blank and got the wrong password message, then i tried with the administrator's username and password with the same results. What should i do now? To just uninstall and reinstall it isn't an option because it's the firm's intranet and it can't stop working.|||Problem solved by reinstalation, :(.sql