Can't Create and Connect to a new Database (.mdf file)

Unfortunately I was sent to this product by my Hosting Site since all I was trying to do was Create and Manage a User Login with authentication to my subsites in MS Frontpage. (rant: Why doesn't Frontpage support this technology?)

Anyway, I have now spent (wasted?) 8 hours downloading, installing, and tyring to configure SQL Express along with MS Visual Web Developer Express for ASP.NET 2.0 ... For the life of me I can't find detailed configuration informatin and setup information to build a SIMPLE database to connect to the VW product. Folk: this HAS to be simpler to do than what you present in the product! This is way too difficult to deal with compare with frontpage.

Is there a simple "how to" link someplace that is specific enough to preclude me from uninstalling this entire suite ?

Hi Cody,

Sounds like you've already put some effort into this, so I really hate to redirect you again, but I believe it will be worth your while to go over and check out ASP.net web. This site is all about web development using ASP.NET and Visual Web Developer. You will find a number of resources on the site which I think should help you. Of particular interest, I think, will be the How Do I video series and the ASP.NET 2.0 Quickstart tutorials. Both of these are available from the Learn tab if the links above don't work and contain samples about handling logins.

Hope this gets you moving in the right direction.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

cant connect to remote db server using SQL 2005 in Vista

Hello
I use SQL 2005 - SQL Server Management Studio to connect to my hosting SQL Server to manage my database , its about 1 month which I have installed Vista and SQL 2005 its working fine in local , but today I just wanted to connect to my remote server and I got this error :

Cannot connect to <My server IP Address>

I thought its a server problem , but its not. I tested it by connecting using same SQL 2005 on a windows xp system , the problem is only in vista,
by the way its SQL 2005 SP2

what can I do to solve this probRight-click on the application and set the option to run in XP mode. Vista sucks.|||Hi,
SQL 2005 is default closed for remote connections.
On the local server, you should configure SQL Server instance and let the remote connections.
You can try the article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx for more detail

Eralper
http://www.kodyaz.com|||NO, you didn't get that,
The remote server which I am connecting to , is a SQL Server 2000 , and its working fine , I can easily connect to this server using SQL 2000 and 2005 through windows xp , the problem is that I can't connect to this server using SQL 2005 through windows Vista,
and I get "Cannot connect to <My server IP Address>"
I think this means its can't even connect to the server to check account details|||is there a firewall in vista that you need to configure?|||No , I have disabled firewall|||HI.
Make sure you can access the remote server over the network!
Check the networkprotocol you are using to connect to the remote sql.
Under the connection properties of management studio==> Network protocol; choose b/w namedpipes and tcp/ip (try switching between them).

Most likely the protocol being used is namedpipes which doesn't allow connection if the client machine is not within the domain remote server is running on or if namedpipes protocol is disabled on remote server.|||I checked each 3 connection protocol (Shared Memory , TCP/IP , namedpipes), but nothing, the same error

:(|||make sure the sql browser service is running on the remote sql server.|||I am sure that everything on the remote sql server is ok , because I easily connect to server with windows xp and sql 2005 the problem is only in windows vista and sql 2005|||somebody help me plz|||I wish we could, but this sounds like the sort of problem that we would have to be looking over your shoulder to spot. It would seem to be a problem with your operating systems, and not the database server, and thus may be outside the scope of our expertise.
Contact Microsquash, and when you do please tell them that blindman says Vista sucks.