Sunday, April 22, 2007

SQL Server 2005 Blues Are Over

Finally, the SQL setup blues are over.

I had some problem with setting up and configuring Microsoft SQL Server 2005 since Friday. Apparently, the changes in Windows Vista's IDE environment prompted massive changes. With the help of some online guides. I found out the solution.

1. The machine name used to run the application must be in upper-casing only.
2. The collation must case-insensitive.
3. For running in Windows Vista, you must install SQL's Service Pack 2 to do so.
4. The User Control feature can be annoying at times, but just click the command to run.
5. Be sure to allow TCP/IP or memory pipes in Configuration Manager. It is an important tool to run and setup before running SQL Server 2005.

After that, it's the usual setup thing in SQL 2005. Finally, it's working. And it's Developer Edition for me.

Wooo Hoooo....


No comments:

Post a Comment

You are welcome to post in any comments that do not trouble readers of the blog.

Providing an ID is recommended. If some reason you wish to use an Anonymous name, please leave a name below your comments. From now on, comments with no names will not be considered for moderation.

LinkWithin

Related Posts Plugin for WordPress, Blogger...