AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, March 07, 2006

How to setup MS SQL Server 2005 or SQL Server Express

With Microsoft SQL Server 2000 or MSDE this was very easy – once you have installed it – it is accessible from the network. But due to improved security this does not work anymore. Now you have to fine-tune SQL Server. There is a Getting Started with the Database Engine tutorial as MSDN site, which can help you. And do not forget that we have a simple AttachDB Utility, which help you to perform simple administration tasks, like Attach/Detach and Backup/Restore in a few clicks!

1 Comments:

Anonymous Kenneth said...

>> With MSDE this was very easy – once you have installed it – it is accessible from the network. But due to improved security this does not work anymore.

Thanks for this information. It clarifies my confusion as to why MSDE 2000 db cannot be networked anymore. Years back it was okay but no longer. I tried and tried but it fails.

In fact a customer of mine uses MsSQL 2005 and the networking of db also fails.

I don't understand why it is so difficult for MS to create a more foolproof system. Terrible when you read all the questions on this subject on the Internet.

7:46 AM  

Post a Comment

<< Home