How to silently uninstall SQL Server 2005 Express

Hi.

I'm trying to perform a silent install/uninstall of SQL Server 2005 Express.
I manage to install silently, but when trying to uninstall with the following command line:

sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<INSTANCENAME>

there is one item left behind - "Microsoft SQL Server Native Client"

Does anyone know how to uninstall this as well?

Also, if MSXML 6.0 is already installed when installing SQL Server 2005 Express, when performing an uninstall with the above command line, MSXML 6.0 is also uninstalled, which may not be the desired outcome.

SQL Server Native Client remains on the box after SQL uninstall if another program is relying on it. If you know no other apps are using it, you can use msiexec to uninstall sqlncli.msi (the native client installer/uninstaller).

Thanks,
Sam Lester (MSFT)

|||Hm,
did a full search for "sqlncli.msi" after uninstalling SQL Server 2005 Express - including hidden files, but I cannot find it?

How to silently uninstall SQL Server 2005 Express

Hi.

I'm trying to perform a silent install/uninstall of SQL Server 2005 Express.
I manage to install silently, but when trying to uninstall with the following command line:

sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<INSTANCENAME>

there is one item left behind - "Microsoft SQL Server Native Client"

Does anyone know how to uninstall this as well?

Also, if MSXML 6.0 is already installed when installing SQL Server 2005 Express, when performing an uninstall with the above command line, MSXML 6.0 is also uninstalled, which may not be the desired outcome.

SQL Server Native Client remains on the box after SQL uninstall if another program is relying on it. If you know no other apps are using it, you can use msiexec to uninstall sqlncli.msi (the native client installer/uninstaller).

Thanks,
Sam Lester (MSFT)

|||Hm,
did a full search for "sqlncli.msi" after uninstalling SQL Server 2005 Express - including hidden files, but I cannot find it?

How to silently uninstall SQL Server 2005 Express

Hi.

I'm trying to perform a silent install/uninstall of SQL Server 2005 Express.
I manage to install silently, but when trying to uninstall with the following command line:

sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<INSTANCENAME>

there is one item left behind - "Microsoft SQL Server Native Client"

Does anyone know how to uninstall this as well?

Also, if MSXML 6.0 is already installed when installing SQL Server 2005 Express, when performing an uninstall with the above command line, MSXML 6.0 is also uninstalled, which may not be the desired outcome.

SQL Server Native Client remains on the box after SQL uninstall if another program is relying on it. If you know no other apps are using it, you can use msiexec to uninstall sqlncli.msi (the native client installer/uninstaller).

Thanks,
Sam Lester (MSFT)

|||Hm,
did a full search for "sqlncli.msi" after uninstalling SQL Server 2005 Express - including hidden files, but I cannot find it?
sql

How to Setup VS Studio 2005 for Import and Export to SQL Server 2005 Express as performed in SQL

Greetings all,

I have just been getting used to the new VS.NET 2005 IDE environment, IT ROCKS!. And this integrated help is pretty useful when we can all collaborate on the many technical topics we all share.

After reading many post blasting Microsoft for NOT including the DTS Import/Export functionality to SQL Server 2005 Express, and many people just threatening to go back to only use SQL Server 2000. I decided to look into this.

And found an actually simple way to do this.

The new Microsoft IDE in VS.NET 2005 includes the ability to define custom tools to be accessible in the Main Tools Menu.

Follow these steps:

1. Click Tools Menu (in VS.NET 2005 IDE)
2. Click External Tools
3. Define name for menu item in the Title text box
4. Define full path and name of executable in the Command text box
5. Define parameters to pass in the Arguments text box

You can launch any external application here, and a Menu Item is created. You can also pass parameters to this, and this is how we can do some DTS stuff if you do have SQL Server 2000 installed on either your local system, or a system you can access from your computer.

There is a program that ships with SQL Server 2000 call DTSWIZ.EXE. This
is used from the SQL Server Enterprise Manager. (Note: Make sure you have sufficient access to this location)

To use this, first check out the parameters is expects.

1. Shell out to DOS
Click Start, Run, then type in cmd and hit [ENTER]

2. Navigate to location of SQL Server
\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe

This program supports several parameters, you can launch this wizard in several ways.

example:

To start up DTS Import
dtswiz.exe /n /i

To start up DTS Export
dtswiz.exe /n /x

Once you have this in place, then you want to Import Data. Simply choose
Import from the Tools menu (the External Tool item you created above)

1. In the Data Source drop down, select SQL Native Client.
2. Click Properties Button (lower left corner)
3. In the Data Source of this screen, put full path to SQL 2005 Express Database
4. Choose authentication
5. Choose Exit

Follow the remaining steps of the wizard for selecting which tables you wanted to import.

This has been thoroughly tested on the following:

Pentium 3 Two-Gigerhz Dual Processer
1 Gig Memory
Running Visual Studio 2005, SQL Server 2005 Express
and SQL Server 2000 located on a different Server computer.

I've simply created a Mapped Network drive to the
\Program Files\Microsoft SQL Server\80\Tools\Binn
to have access to the tools.

Hopefully others can use this activating IMPORT and EXPORT functionality
so you can port some of your smaller SQL Server 2000 databases to a different data tier model.

I am starting to contribute here, hopefully others will get themself a Windows Password account if you don't have one already, and start sharing more material between ourselves.

?/"/"[ Dreams pull reality closer to use all ]"\"\"
Dim Mind as New Mind
If Mind.Thinking then
Mind.GetThought("VS.NET")
If Mind.Feelings = Feel.FreakingROCKS then
Call KeepThingsRockin
End If
End If
CodeDoctor

I can't get this to work on Vista. I get an error that DTS couldn't create an instance.
|||

Am new to this. I have access to the DTS WIZ but cannot edit the saved package in SSE.

Going Mad!!!

Sudip

sql

How to Setup VS Studio 2005 for Import and Export to SQL Server 2005 Express as performed in SQL

Greetings all,

I have just been getting used to the new VS.NET 2005 IDE environment, IT ROCKS!. And this integrated help is pretty useful when we can all collaborate on the many technical topics we all share.

After reading many post blasting Microsoft for NOT including the DTS Import/Export functionality to SQL Server 2005 Express, and many people just threatening to go back to only use SQL Server 2000. I decided to look into this.

And found an actually simple way to do this.

The new Microsoft IDE in VS.NET 2005 includes the ability to define custom tools to be accessible in the Main Tools Menu.

Follow these steps:

1. Click Tools Menu (in VS.NET 2005 IDE)
2. Click External Tools
3. Define name for menu item in the Title text box
4. Define full path and name of executable in the Command text box
5. Define parameters to pass in the Arguments text box

You can launch any external application here, and a Menu Item is created. You can also pass parameters to this, and this is how we can do some DTS stuff if you do have SQL Server 2000 installed on either your local system, or a system you can access from your computer.

There is a program that ships with SQL Server 2000 call DTSWIZ.EXE. This
is used from the SQL Server Enterprise Manager. (Note: Make sure you have sufficient access to this location)

To use this, first check out the parameters is expects.

1. Shell out to DOS
Click Start, Run, then type in cmd and hit [ENTER]

2. Navigate to location of SQL Server
\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe

This program supports several parameters, you can launch this wizard in several ways.

example:

To start up DTS Import
dtswiz.exe /n /i

To start up DTS Export
dtswiz.exe /n /x

Once you have this in place, then you want to Import Data. Simply choose
Import from the Tools menu (the External Tool item you created above)

1. In the Data Source drop down, select SQL Native Client.
2. Click Properties Button (lower left corner)
3. In the Data Source of this screen, put full path to SQL 2005 Express Database
4. Choose authentication
5. Choose Exit

Follow the remaining steps of the wizard for selecting which tables you wanted to import.

This has been thoroughly tested on the following:

Pentium 3 Two-Gigerhz Dual Processer
1 Gig Memory
Running Visual Studio 2005, SQL Server 2005 Express
and SQL Server 2000 located on a different Server computer.

I've simply created a Mapped Network drive to the
\Program Files\Microsoft SQL Server\80\Tools\Binn
to have access to the tools.

Hopefully others can use this activating IMPORT and EXPORT functionality
so you can port some of your smaller SQL Server 2000 databases to a different data tier model.

I am starting to contribute here, hopefully others will get themself a Windows Password account if you don't have one already, and start sharing more material between ourselves.

?/"/"[ Dreams pull reality closer to use all ]"\"\"
Dim Mind as New Mind
If Mind.Thinking then
Mind.GetThought("VS.NET")
If Mind.Feelings = Feel.FreakingROCKS then
Call KeepThingsRockin
End If
End If
CodeDoctor

I can't get this to work on Vista. I get an error that DTS couldn't create an instance.
|||

Am new to this. I have access to the DTS WIZ but cannot edit the saved package in SSE.

Going Mad!!!

Sudip

How to Setup VS Studio 2005 for Import and Export to SQL Server 2005 Express as performed in

Greetings all,

I have just been getting used to the new VS.NET 2005 IDE environment, IT ROCKS!. And this integrated help is pretty useful when we can all collaborate on the many technical topics we all share.

After reading many post blasting Microsoft for NOT including the DTS Import/Export functionality to SQL Server 2005 Express, and many people just threatening to go back to only use SQL Server 2000. I decided to look into this.

And found an actually simple way to do this.

The new Microsoft IDE in VS.NET 2005 includes the ability to define custom tools to be accessible in the Main Tools Menu.

Follow these steps:

1. Click Tools Menu (in VS.NET 2005 IDE)
2. Click External Tools
3. Define name for menu item in the Title text box
4. Define full path and name of executable in the Command text box
5. Define parameters to pass in the Arguments text box

You can launch any external application here, and a Menu Item is created. You can also pass parameters to this, and this is how we can do some DTS stuff if you do have SQL Server 2000 installed on either your local system, or a system you can access from your computer.

There is a program that ships with SQL Server 2000 call DTSWIZ.EXE. This
is used from the SQL Server Enterprise Manager. (Note: Make sure you have sufficient access to this location)

To use this, first check out the parameters is expects.

1. Shell out to DOS
Click Start, Run, then type in cmd and hit [ENTER]

2. Navigate to location of SQL Server
\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe

This program supports several parameters, you can launch this wizard in several ways.

example:

To start up DTS Import
dtswiz.exe /n /i

To start up DTS Export
dtswiz.exe /n /x

Once you have this in place, then you want to Import Data. Simply choose
Import from the Tools menu (the External Tool item you created above)

1. In the Data Source drop down, select SQL Native Client.
2. Click Properties Button (lower left corner)
3. In the Data Source of this screen, put full path to SQL 2005 Express Database
4. Choose authentication
5. Choose Exit

Follow the remaining steps of the wizard for selecting which tables you wanted to import.

This has been thoroughly tested on the following:

Pentium 3 Two-Gigerhz Dual Processer
1 Gig Memory
Running Visual Studio 2005, SQL Server 2005 Express
and SQL Server 2000 located on a different Server computer.

I've simply created a Mapped Network drive to the
\Program Files\Microsoft SQL Server\80\Tools\Binn
to have access to the tools.

Hopefully others can use this activating IMPORT and EXPORT functionality
so you can port some of your smaller SQL Server 2000 databases to a different data tier model.

I am starting to contribute here, hopefully others will get themself a Windows Password account if you don't have one already, and start sharing more material between ourselves.

?/"/"[ Dreams pull reality closer to use all ]"\"\"
Dim Mind as New Mind
If Mind.Thinking then
Mind.GetThought("VS.NET")
If Mind.Feelings = Feel.FreakingROCKS then
Call KeepThingsRockin
End If
End If
CodeDoctor

I can't get this to work on Vista. I get an error that DTS couldn't create an instance.|||

Am new to this. I have access to the DTS WIZ but cannot edit the saved package in SSE.

Going Mad!!!

Sudip

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
JoeHere's a quote from 2005 BOL:
"Note:
Database Mail is not available in SQL Server 2005 Express Edition. "
Consider using xp_smtp_sendmail (Google) instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:57DCA9FF-798E-440F-AF6C-B4C6B19D08F2@.microsoft.com...
> Hi All,
> I know the full version of SQL 2005 uses SMTP, and I know where to set it
> up. I just installed SQL express and I can't find where to setup mail.
> TIA,
> Joe
>|||Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:
>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
Joe
Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:

>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
JoeHere's a quote from 2005 BOL:
"Note:
Database Mail is not available in SQL Server 2005 Express Edition. "
Consider using xp_smtp_sendmail (Google) instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:57DCA9FF-798E-440F-AF6C-B4C6B19D08F2@.microsoft.com...
> Hi All,
> I know the full version of SQL 2005 uses SMTP, and I know where to set it
> up. I just installed SQL express and I can't find where to setup mail.
> TIA,
> Joe
>|||Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:

>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to setup SQL Express for course use

I will be teaching a web scripting course, and I would like to switch from using MS Access to MS SQL as a database. Please forgive my ignorance, as have much to learn about SQL Express. We have installed SQL Express on a web server (windows box).

Question1:
is SQL like MS Access, in that the SQL Express software should be installed locally on the users machine. The user will create databases and tables locally, then upload the resulting database(s) to the appropriate folder on the web server along with web scripting files?
-- OR
is MS SQL like MySQL, where the db is installed on the remote server, and user accounts are created within the database with appropriate priv.'s. The user logs in to the db application remotely to create tables within a given database.

You can install it either way (locally or remotely). I could see advantages to both. If they install it locally to each machine, you wouldn't have to worry about setting up users/permissions/remote connections, etc on a central server. But if you install it on a central server, you only have to go through the install one time and don't have to worry about the student upload/transfer.

If you don't have much experience with Express, I'd suggest installing Express Advanced so you can get the GUI management tools as well.

Thanks,
Sam Lester (MSFT)

How to setup SQL auth. for SQLserver 2005 express?

Hi,

I can't seem to set up SQL server authentication for SQLserver 2005 Express edition..

I simply can't find the settings for that. I have Management Studio Express installed and I can see the SA user but I can't login using that user.. I know that there's supposed to be a setting for turning on SQL auth. but it's not like it used to be in Enterprise manager :) so I can't find it.. ;/ I couldn't find any documentation on how to do this so I thought I'll try here..

(I need SQL auth for my project :) - it must be done with that..)

Thanks in advance,

ZenX

Hi,

have a look in on my site in the Screencast section, there is a detailed Screencast for this which will show you the steps.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

How to setup SelectParameters programmatically?

Hi,

I am using Visual Web Developer 2005 Express Edition.

I am trying to SELECT three information fields from a table when the Page_Load take place (so I select the info on the fly). The refering page, sends the spesific record id as "Articleid", that looks typically like this: "http://localhost:1424/BelaBela/accom_Contents.aspx?Articleid=2". I need to extract the "Article=2" so that I can access record 2 (in this example).

How do I define the SelectParameters or QueryStingField on the fly so that I can define the WHERE part of my query (see code below). If I remove the WHERE portion, then it works, but it seem to return the very last record in the database, and if I include it, then I get an error "Must declare the scalar variable @.resortid". How do I programatically set it up so that @.resortid contains the value that is associated with "Articleid"?

My code is below.

Thank you for your advise!

Regards
Jan

/******************************************************************************** RETRIEVE INFORMATION FROM DATABASE*******************************************************************************/// specify the data sourcestring connContStr = ConfigurationManager.ConnectionStrings["tourism_connect1"].ConnectionString;SqlConnection myConn =new SqlConnection(connContStr);// define the command queryString query ="SELECT resortid, TourismGrading, resortHits FROM Resorts WHERE ([resortid] = @.resortid)";SqlCommand myCommand =new SqlCommand(query, myConn);// open the connection and instantiate a datareadermyConn.Open();SqlDataReader myReader = myCommand.ExecuteReader();// loop thru the readerwhile (myReader.Read()){ Label5.Text = myReader.GetInt32(0).ToString(); Label6.Text = myReader.GetInt32(1).ToString(); Label7.Text = myReader.GetInt32(2).ToString();}// close the reader and the connectionmyReader.Close();myConn.Close();

You can try the following, but you may need to change the resotid if it is an integer type.

SqlCommand myCommand =new SqlCommand(query, myConn);

myCommand.Parameters.Add("@.resortid"

,SqlDbType.NVarChar, 10).Value =Request.QueryString("resortid");|||

Something like this: 

String ArticleID;if (Request.QueryString["ArticleID"] !=null) ArticleID = Request.QueryString["ArticleID"];else// handle bad parameterSqlParameter param =new SqlParameter();param.ParameterName ="@.resortId";param.Value = ArticleID.ToInt32();myConn.Parameters.Add(param);

|||

Hi Limno and SGWellens,

Thanks for your help - I managed to get it working like a charm!

Regards

Jan

How to Setup Merge replication with sql express

I have a Windows Mobile aplication that uses merge replication to synchronize between sql compact and full sql Enterprise edition and It works great. Instantiating the SqlCeReplication object setting it's properties and calling Synchronize on it is pretty simple assuming everything is setup properly at the publisher.

For the life of me I can't figure out how to do this on the desktop (Programatically setup a subscription and create a database using objects in the System.Replication Namespace and hopefully call Synchronize on it).

Someone please point me in the right direction.

Thanks,

Patrick

See topic "Programming with Replication Management Objects", http://msdn2.microsoft.com/en-us/library/ms146869(SQL.90).aspx.

|||

Look at the MergeSynchronizationAgent class.

Here is some sample code in C#:

Code Snippet

_mergeAgent = newMergeSynchronizationAgent();

_mergeAgent.Publication = _publication;

_mergeAgent.Publisher = _publisher;

_mergeAgent.PublisherDatabase = _publisherDB;

_mergeAgent.PublisherSecurityMode = SecurityMode.Integrated;

_mergeAgent.Distributor = _distributor;

_mergeAgent.DistributorLogin = _distributorLogin;

_mergeAgent.DistributorPassword = _distributorPassword;

_mergeAgent.DistributorSecurityMode = SecurityMode.Standard;

_mergeAgent.Subscriber = _subscriber;

_mergeAgent.SubscriberDatabase = _subscriberDB;

_mergeAgent.SubscriberLogin = _subscriberLogin;

_mergeAgent.SubscriberPassword = _subscriberPassword;

_mergeAgent.SubscriberSecurityMode = SecurityMode.Standard;

_mergeAgent.SubscriptionType = SubscriptionOption.Pull;

_mergeAgent.LoginTimeout = _LoginTimeOut;

_mergeAgent.QueryTimeout = _QueryTimeOut;

_mergeAgent.Synchronize();

Hope this helps!

How to set right utf-8 in sql server 2005 db?

Hello,

I try to insert some data in Vietnamese into sql server db from Sql server management studio express.

I enter an insert query with some unicode data like this 'm?t hai ba b?n n?m sáu b?y tám chín m??i', and I expect the db should contain the same text as above.

However, what I retrieved is 'm?t hai ba b?n nam sáu b?y tám chín mu?i'.

Can anyone help? Many thanks.

maivangho

Hi~ you may check you server's regional settings in control panel, and set all those to your language related, and check<globalization> section of config file.

If it still doesn't work, underSystem.Text there are some classes for encoding/decoding, you may try encode your data before putting them into DB... though this is not a good walkaround..

How to set my SQL Server Express to remote?

Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it? :)

this error i get when i trying to connet from my laptop to my server

TITLE: Connect to Server

Cannot connect to 192.168.47.128\SQLEXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

i hob i can be helpt :)

Hi,

I hope you do the next.

1. Allow SQL Server to pass via you firewall on your server computer.

2. Allow remote connection (using TCP/IP) from “SQL Server 2005 Surface Area Configuration”

So, you must also check “enable” to “yes” for certain IP address.

You can do this from Start button – Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager

Then from left part of appear window you must choose “SQL Server 2005 Network Configuration” – “Protocols for SQLEXPRESS”. From right part of the window with right button of the mouse you must click on “TCP/IP” and choose “properties”. Then from appear popup window click on “IP Addresses”. And then against your IP “192.168.47.128” must choose “Yes” to “enable”.

For connect try to use the next format: IP (or name of the computer), Port or in your case 192.168.47.128, Port

My additional advice => first try to make connection on server computer to him self with 192.168.47.128, Port and if it is ok => try with computers from network. If you can make connection on your server computer, but you can’t make with network computers then the problem is in the firewall.

Regards!

Hristo Markov

|||

I am having the same problem, but with my own computer. I couldn't connect to the server because of the TCP/IP

|||

Hi ive read your problem and i can say that i faced the same problem, i found a solution to my problem, i don't know if this should work for you but try it out. here it is

1st step - Enable your TCP/IP for remote sql server on the sql server surface area configuration

2nd step - Then open you SQL server configuration manager and browse the protocols for SQL EXPRESS, propeties and go to the IPAdresses

Active Yes

Enable Yes

IP Address 192.168.1.47 ( this is the IP where your sql server resides)

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

Then go down where its the IPALL and enter the following

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

save your settings and restart your sql server express service

Then use 192.168.1.47\SQLEXPRESS as your connnection string *note that you did not need to enter the port number as you previously use the 1433 default sql port.so that any query will automatically first seach into the default port

lastly if u intent to use the service over a network, u need to enable port 1433 on your firewall if you did not previously perform that, but again as said in the previous post, test if it works first locally on your sql server machine..

let me know if it works.. bye

How to set my SQL Server Express to remote?

Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it? :)

this error i get when i trying to connet from my laptop to my server

TITLE: Connect to Server

Cannot connect to 192.168.47.128\SQLEXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

i hob i can be helpt :)

Hi,

I hope you do the next.

1. Allow SQL Server to pass via you firewall on your server computer.

2. Allow remote connection (using TCP/IP) from “SQL Server 2005 Surface Area Configuration”

So, you must also check “enable” to “yes” for certain IP address.

You can do this from Start button – Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager

Then from left part of appear window you must choose “SQL Server 2005 Network Configuration” – “Protocols for SQLEXPRESS”. From right part of the window with right button of the mouse you must click on “TCP/IP” and choose “properties”. Then from appear popup window click on “IP Addresses”. And then against your IP “192.168.47.128” must choose “Yes” to “enable”.

For connect try to use the next format: IP (or name of the computer), Port or in your case 192.168.47.128, Port

My additional advice => first try to make connection on server computer to him self with 192.168.47.128, Port and if it is ok => try with computers from network. If you can make connection on your server computer, but you can’t make with network computers then the problem is in the firewall.

Regards!

Hristo Markov

|||

I am having the same problem, but with my own computer. I couldn't connect to the server because of the TCP/IP

|||

Hi ive read your problem and i can say that i faced the same problem, i found a solution to my problem, i don't know if this should work for you but try it out. here it is

1st step - Enable your TCP/IP for remote sql server on the sql server surface area configuration

2nd step - Then open you SQL server configuration manager and browse the protocols for SQL EXPRESS, propeties and go to the IPAdresses

Active Yes

Enable Yes

IP Address 192.168.1.47 ( this is the IP where your sql server resides)

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

Then go down where its the IPALL and enter the following

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

save your settings and restart your sql server express service

Then use 192.168.1.47\SQLEXPRESS as your connnection string *note that you did not need to enter the port number as you previously use the 1433 default sql port.so that any query will automatically first seach into the default port

lastly if u intent to use the service over a network, u need to enable port 1433 on your firewall if you did not previously perform that, but again as said in the previous post, test if it works first locally on your sql server machine..

let me know if it works.. bye

How to set my SQL Server Express to remote?

Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it? :)

this error i get when i trying to connet from my laptop to my server

TITLE: Connect to Server

Cannot connect to 192.168.47.128\SQLEXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

i hob i can be helpt :)

Hi,

I hope you do the next.

1. Allow SQL Server to pass via you firewall on your server computer.

2. Allow remote connection (using TCP/IP) from “SQL Server 2005 Surface Area Configuration”

So, you must also check “enable” to “yes” for certain IP address.

You can do this from Start button – Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager

Then from left part of appear window you must choose “SQL Server 2005 Network Configuration” – “Protocols for SQLEXPRESS”. From right part of the window with right button of the mouse you must click on “TCP/IP” and choose “properties”. Then from appear popup window click on “IP Addresses”. And then against your IP “192.168.47.128” must choose “Yes” to “enable”.

For connect try to use the next format: IP (or name of the computer), Port or in your case 192.168.47.128, Port

My additional advice => first try to make connection on server computer to him self with 192.168.47.128, Port and if it is ok => try with computers from network. If you can make connection on your server computer, but you can’t make with network computers then the problem is in the firewall.

Regards!

Hristo Markov

|||

I am having the same problem, but with my own computer. I couldn't connect to the server because of the TCP/IP

|||

Hi ive read your problem and i can say that i faced the same problem, i found a solution to my problem, i don't know if this should work for you but try it out. here it is

1st step - Enable your TCP/IP for remote sql server on the sql server surface area configuration

2nd step - Then open you SQL server configuration manager and browse the protocols for SQL EXPRESS, propeties and go to the IPAdresses

Active Yes

Enable Yes

IP Address 192.168.1.47 ( this is the IP where your sql server resides)

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

Then go down where its the IPALL and enter the following

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

save your settings and restart your sql server express service

Then use 192.168.1.47\SQLEXPRESS as your connnection string *note that you did not need to enter the port number as you previously use the 1433 default sql port.so that any query will automatically first seach into the default port

lastly if u intent to use the service over a network, u need to enable port 1433 on your firewall if you did not previously perform that, but again as said in the previous post, test if it works first locally on your sql server machine..

let me know if it works.. bye

How to set and use SQL Server Express 2005 after installation?

I have never used SQL Server, except that I did use MS Access, so after I downloading and installing the SQL Server Express 2005 ... I really do not know how to make it works!

1. Let say I would like to create a table at my local computer (1st) as a Server, how I do it (configuration)?

2. Then I have a second PC, as a client how I link to that table?

Might be they are 2 silly questions, but I would like to try out the new SQL Server Express and compare what are the better features with MS Access!

Thanks to any help

hi,

Anh Truong wrote:

I have never used SQL Server, except that I did use MS Access, so after I downloading and installing the SQL Server Express 2005 ... I really do not know how to make it works!

1. Let say I would like to create a table at my local computer (1st) as a Server, how I do it (configuration)?

SQLExpress, as SQL Server as well, is "just" a database engine (actually lot more than just that), but is not "an application" as well as you consider Access... actually, in Access world, the situation is the same as JET is the database engine and Access is the application intended to manage and interact with JET database(s)...

so, in Access, you just open "Access" and create your own database(s) and database's objects, where SQL Server/SQLExpress does not provide an ambient like that.. they feature other management tools... command line tools like SqlCMD.exe, or visual tools like SQL Server Management Studio (SQL Server Management Studio Express, for SQLExpress edition)... with these UI tools, you can visually interact with your instance, manage database(s) and database's object(s)... or, like in SqlCMD.exe, you can execute straigth Transact-SQL commands to perform both DDL and DML commands...

2. Then I have a second PC, as a client how I link to that table?

you are still "thingking" in term of JET/Access databases, a file based engine, where SQL Server/SQLExpress is a traditional client/server based architecture.. you do not create objects on a client... you always create them on the file system of the computer running the SQL Server instance, as you do not directly interact with the related files, but with the "server" only... it's up to the server to manage and interact with the underlying physical files..

as regard "remote" connections, you do not "link that tables"... you connect to the remote server, interacting with the desired database, querying relative objects like tables, procedures, views, .....

just remember SQLExpress installs by default disabling network protocols and remote connections... use SQL Server Configuration Manager to enable the desired network protocol, and Surface Area Configuration to enable remote connections over TCP/IP..
actually even managing the eventual FireWall comes to play, where you have to enable connections over the database engine used port (or binaries) and SQLBrowser port as well (UDP1434)..

SQLBrowser is an additional service used to resolve connections to Named Instances.. it listen on UDP1434 for incoming connections initiated by remote clients, it the queryies the Named Instance for it's used TCP/IP port and redirect the incoming connection to that port the instance is listening on..

regards