how to run and connect sql sever 2005 express database when running software to another pc

Question

hi all

i am a newbie in sqlserver 2005 database. i create a database on the local machine where was i created database and connect with my project.  The database on the local machine  with my project will running successfully but when i run this project to any other pc the project has not been run due to non connectivity of my database .  I also install sql server management studio on the target machine for attaching database but there is no server name to connectivity. I don't know why sql server name is blank.

I only asked from you that what is needed to connect sqlserver 2005 express database for running my project on any other target pc where i want to run.

is i need to install complete sql express version with management studio or any other software for connectivity of my database or anything else to target pc.

Answer 1

hi all

i am a newbie in sqlserver 2005 database. i create a database on the local machine where was i created database and connect with my project.  The database on the local machine  with my project will running successfully but when i run this project to any other pc the project has not been run due to non connectivity of my database .  I also install sql server management studio on the target machine for attaching database but there is no server name to connectivity. I don't know why sql server name is blank.

I only asked from you that what is needed to connect sqlserver 2005 express database for running my project on any other target pc where i want to run.

is i need to install complete sql express version with management studio or any other software for connectivity of my database or anything else to target pc.

Answer 2

hi all

i am a newbie in sqlserver 2005 database. i create a database on the local machine where was i created database and connect with my project.  The database on the local machine  with my project will running successfully but when i run this project to any other pc the project has not been run due to non connectivity of my database .  I also install sql server management studio on the target machine for attaching database but there is no server name to connectivity. I don't know why sql server name is blank.

I only asked from you that what is needed to connect sqlserver 2005 express database for running my project on any other target pc where i want to run.

is i need to install complete sql express version with management studio or any other software for connectivity of my database or anything else to target pc.

Answer 3

I don't know why sql server name is blank

Hello,

If it's blank / you can't find it with the search option, then simply enter the name of the SQL Server instance, e.g. OtherMachineName\SQLEXPRESS (if you installed it as named instance SQLEXPRESS).

Make sure that remote connections are enabled, see http://support.microsoft.com/kb/914277

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

See your double post: http://social.msdn.microsoft.com/Forums/de-DE/sqlgetstarted/thread/4abebaf5-55c5-4a43-afb3-7ca43c7760a3

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 5

As Olaf mentioned in the other thread, it sounds like a connection issue.  Check this thread as well to cover the "can't connect" bases.... services started, ports open in firewall, protocals enabled, etc.

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/282ed42a-2ced-4c1a-bafc-b44168d52679

Thanks,
Sam Lester (MSFT)

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

Answer 6

when i enter the server instance  F.R.I.E.N.D.S\SQLEXPRESS the following error occurred

Answer 7

why the dots in the name of the computer ?

could you ping the computer using the server name "F.RI.E.N.D.S" ?

There may be several reason why you can connect it locally but not from a remote pc:

1. firewall is blocking connection to SQL server

2. you haven't enabled remote connection on the SQL Express instance (the default setting)

3. the server name can be resolved

4. the server is not reachable from your pc

Especially point 1 & 2 are likely to be your problem.

Start SQL Server Management Studio locally and connect to the local SQL Server Express instance. In the Object Explorer view right click on the server name and open the property dialog. in the bottom there's a checkbox "Allow remote connection" - check it.

Answer 8

why posting the same topic multiple times ?

Answer 9

i cannot attach database by using remote connection i only use standalone connection on the target machine (any pc) then why allow remote connection to checked.  tell me only how to connect and attach my database on the target machine as standalone. for this purpose can i install management studio or sql express on the target machine or just install management studio for attaching database

it is also note that i only install the sql express management studio on the target machine. it is enough or need to install sql express

Answer 10

i cannot attach database by using remote connection i only use standalone connection on the target machine (any pc) then why allow remote connection to checked.  tell me only how to connect and attach my database on the target machine as standalone. for this purpose can i install management studio or sql express on the target machine or just install management studio for attaching database

it is also note that i only install the sql express management studio on the target machine. it is enough or need to install sql express

if you want to use the database locally than you've to install a local SQL Server engine, e.g SQL Server Express.

Installing SQL Server Management Studio does not install SQL Server Express alway as it depends on the installation you've downloaded.

Uuse this download link Microsoft SQL Server 2005 Express Edition Service Pack 4

than you need to download & install  SQLEXPR_ADV.EXE only as it contains SQL Server Express 2005 with Advanced Services with Service Pack 4 already included.

But I would recommand to use SQL Server 2008R2 Express Edition or even SQL Server 2012 Express edition and not 2005 version as that had already passed it mainstream support.

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.