Hello,

I am testing/learning SQL 2005 workgroug that came with Windows SBS 2003
Premium and I would like to know:

- Is there a way to set the databases on another drive than the C: drive
during the install.
- Do I have to setup firewall exceptions in order to access the SQL server.
Currently it does not work unless I turn off the firewall.

Thank you.

Eric

Eric (eric (AT) mail (DOT) com) writes:
First of all, when you create a database, you can always specify the path.
To change the default location, you can right-click the server in
Object Explorer, and choose Properties and then select Database Settings.

But I believe you can change this at Setup as well. In such case that is
in the screen where you select features. But my memory is vague; it was a
while since I ran that Setup.

The SQL Server Setup does not touch your firewall, so need to open the
firewall yourself. You should not have to close down the firewall entirely.
But you are not planning to expose SQL Server on the Internet, I assume?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I was originally thinking about the system databases. It would just be
easier to be able to set the path during the install rather that trying to
move them later on.

Closing down the firewall was just a quick test to find out if it was
involved in my communication problem with the SQL server (while setting up
the ODBC connection.)
Would you happen to know what exception needs to be created?

Thank you.

Eric






"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote