SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Only local access to SQL Server 2005 Express ed. ?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ventimiglia
Starting Member

6 Posts

Posted - 08/02/2007 :  04:21:22  Show Profile  Reply with Quote
Hello!
I run an application with a SQL Server 2005 Express edition.

I read under

Start 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 Connections

That:
"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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/02/2007 :  22:20:54  Show Profile  Reply with Quote
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.

Go to Top of Page

Ventimiglia
Starting Member

6 Posts

Posted - 08/03/2007 :  06:05:30  Show Profile  Reply with Quote
Thanks for your reply.

A follow-up question on connectivity;

Must the SQL Server Browser be running?

I read here:
http://www.datamasker.com/SSE2005_NetworkCfg.htm br / " target="_blank"> br / http://www.datamasker.com/SSE2005_NetworkCfg.htm br /

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?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/03/2007 :  10:32:27  Show Profile  Reply with Quote
Depends on your sql instance settings, may not needed if sql has static ip address and port number.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000