Welcome to MSDN Blogs Sign in | Join | Help

May 2006 - Posts

How to install SQL 2005 from the command prompt and using .ini file ?

Posted Sunday, May 28, 2006 1:49 AM by Sanchan
I wanted to publish this quick blog tonight to answer some of the questions that I have received recently regarding installation from an .ini file. Microsoft has published a great MSDN article that lists the commands and options to use for installing Read More...
11 Comments

TIP - How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

Posted Sunday, May 28, 2006 12:14 AM by Sanchan
I came across this excellent blog by Euan Garden, who is a Group Program Manager at Microsoft. http://blogs.msdn.com/euanga/archive/2006/05/04/585513.aspx In this blog, he tries to answer the most commonly asked question - how to hide databases from users Read More...
0 Comments
Filed under:

Microsoft launches cumulative package for SQL Server 2005

Posted Saturday, May 27, 2006 11:57 PM by Sanchan
Microsoft launched SQL Server 2005 in November, 2005. This build was called the RTM version. In April, 2006, we launched Service Pack 1 which included a lot of new features and fixes for known bugs. Check out my blog here to learn more about SP1. However, Read More...
0 Comments

TIP - I changed the password for the domain account that SQL uses as startup account...

Posted Thursday, May 04, 2006 10:49 PM by Sanchan
Due to your company's password policies, you might have to change the password of the domain account used as the startup account by SQL Server services. Your changes will be reflected in the active directory. Next time, when SQL Server services try to Read More...
2 Comments
Filed under:

TIP - Should I use a Domain Account OR a Local System Account for SQL Server services?

Posted Thursday, May 04, 2006 10:21 PM by Sanchan
I wanted to post this quick blog to answer a very common question - domain vs local system account for SQL Server services. All this information is out there at Books Online. So I will just put references here. Local System Account is a very privileged Read More...
0 Comments
Filed under:

TIP - How to find out the collation in SQL Server 2005?

Posted Wednesday, May 03, 2006 10:43 PM by Sanchan
In SQL Server 2005, you can set collations at the following levels: - Server Level o You set the collation of the server at the time of setup. o The only way to change that is to re-install SQL Server with the right collation. o To find out the existing Read More...
1 Comments
Filed under:

TIP - How to change the startup account in SQL 2005?

Posted Wednesday, May 03, 2006 10:14 PM by Sanchan
Generally, you would set the startup accounts for SQL Server services during the startup. However, there are times when you might want to change it after installation. Many DBAs are so used to Services.msc console that they use it to change the startup Read More...
6 Comments
Filed under:

TIP - Do we need to run SQL Server under an administrative account?

Posted Wednesday, May 03, 2006 10:00 PM by Sanchan
The answer to this question is NO. However, there are some special considerations, so read on. You don’t need to run SQL Server services under an administrative account or a Domain Admin account – neither on a standalone box nor on a cluster. You have Read More...
2 Comments
Filed under:
 
Page view tracker