How to connect to ms sql server

[shikha]

Hi Everyone,

Very new with MS SQL Server. I got the MS SQL added on the web server, and
i currently have site created in frontpage using MS access and ASP. i would
like to replace Access wiht this SQL Server...any idea on how to do that?

And web hosting created the database for me in the MS SQl...how do i add the
table in this database, which i can connect to the site?

Any help wil be greatly appreciated!!!

thanks,
Shikha

 

[Mark Fitzpatrick]

You would need to use the SQL Enterprise Manager to connect to SQL Server
and build tables in it. I think MS used to make the SQL Server
administration tools as a seperate download but I'm not sure if they still
do.If they don't, you can buy a copy of SQL Server Developer Edition for
about $40 to $50 and this includes a local copy you can work with as well as
the tools to work with any SQL Server.

Whenever you're in doubt of a connection string, check out
http://www.connectionstrings.com/ They have the format for just about every
connection string you can think as well as the variations for different
connection technologies.