Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Local SQL Server database

Author  Topic 

DJSQL
Starting Member

1 Post

Posted - 2010-12-14 : 07:19:29
Hi there!

I want to create a sql database on my local computer so I can connect to it with html web pages also locally on my machine.

I will be using SQL 2005 Management Studio Express.

However I see it asks for a server name, authentication etc.

How could I set this up to say my laptop is the server? Do I need to install Apache and then use my IP?

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-14 : 13:19:05
Authentication will depend on what you want to setup. Trusted connection/Windows authentication is preferred, however SQL authentication is very common for web sites.

You can use (local) for your local machine. I prefer to use HostName though. Make sure you tack on your instance name if you installed a named instance. SQL Express typically uses HostName\SQLEXPRESS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -