Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ventimiglia
Starting Member
6 Posts |
 Posted - 2007-08-02 : 04:21:22
|
| Hello!I run an application with a SQL Server 2005 Express edition.I read underStart menu--> all programs--> Microsoft SQL Server Express--> Configuration Tools --> SQL Server 2005 Surface Area Configuration--> Surface Area Configuration for Services and Connections--> Database Engine --> Remote ConnectionsThat:"By default, SQL SERver 2005 Express, Evaluation and Developer editions allow local client connetctions only. Enterprise, Standard and Workgroup editions also listens for remote client connections over TCP/IP. Use the options below to change the protocols on which SQL Server listens for incoming client connections. TCP/UP is preferred over named pipes because it requeres fewer ports to be opened across the firewall."Here I chose the option "Local and remote connections only, using TCP/IP only".But still, does this mean that other users can't connect to my database since I'm running the Express edition?If that's the case, could this be changed by using mySQL instead?Is it hard to transfer a MS SQL Server .mdf database file into a new mySQL database? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 22:20:54
|
| You can enable remote access in Surface Area Configuration tool, enable tcp/ip in configuration manager, and ensure sql server browser service is running. Once set, everyone on your network can access it as long as they have sql login account. By the way, you can't transfer a MS SQL Server .mdf database file into a new mySQL database. Need ssis package or bcp data in sql tables to file then load to MySql table with proper tool. |
 |
|
|
Ventimiglia
Starting Member
6 Posts |
Posted - 2007-08-03 : 06:05:30
|
| Thanks for your reply.A follow-up question on connectivity;Must the SQL Server Browser be running?I read here:[url]http://www.datamasker.com/SSE2005_NetworkCfg.htm[/url]that for remote access to be allowed:"- Enable the TCP/IP protocol using the Surface Area Configuration Utility - Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility - Make sure the SQL Server browser is started. Note this step is optional. It is possible to set the SQL Server instance to use a fixed IP address - but this is non-standard for named instances. - Make sure SQL Server and SQL Server Browser are exempted by the firewall on the server machine. This is done by putting sqlservr.exe and sqlbrowser.exe as an exception in the windows firewall. "Is it important to have a SQL Server browser running? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 10:32:27
|
| Depends on your sql instance settings, may not needed if sql has static ip address and port number. |
|
|
|
|
|
|
|
|
Only local access to SQL Server 2005 Express ed. ?