How Can One Connect (remotely) To SQLExpress Which Is Installed On Windows XP Home

Jun 27, 2006

Hi all,

I have to deal with a private network of laptops which are all equiped with preinstalled "Windows XP home"

I've installed SQLExpress on one of these, but I cannot connect on it from the rest of the laptops. (I've successfuly done this with "Windows XP profesional" though, and local connections work fine as well).

I've already setup the SQLExpress to accept conections throuigh TCP/IP but I can not think of something else. (Security comes to mind, but I do not know how to resolve it on "Windows XP Home").

Thank you

Ioannis





View 6 Replies


ADVERTISEMENT

Cannot Connect Remotely To SQLExpress Via SQL Server Management Studio Express

Oct 31, 2007

 Hi all, I'm having a little trouble connecting to a SQLExpress instance on a remote domain using SQL Server Management Studio Express.I've read that by default the program is set up locally only, so have edited the Surface Area Configuration.  It only gives me the option to edit 'Services and Connections' on the localhost, but have edited the Remote Connections to use TCP/IP and Named Pipes. In the Management Studio, I enter the server name, and login credentials.  On the Connection Properties tab I changed the network protocol to TCP/IP though everytime I attempt to connect I get the following error message:  Any help would be greatly appreciated. Rich 

View 4 Replies View Related

Can Enterprise Evalution Edition Be Installed On Windows XP SP2 Home Edition Now?

Apr 23, 2006

Thanks.

View 2 Replies View Related

Question About Connect To The Sql Server 2000 Installed On Windows Xp Sp2

Aug 31, 2006

Hi

I have another question now.

As the topic said, my sql server 2000 installed on windows xp sp2, the computer's name is "ADMIN" and the server 2000's name is "ADMIN".

When i startup the sql server 2000, it just listening on shared memory and name pipes, not including the "TCP/IP" . So i can not connect to the sql server using the port 1433.

Some people said that the reason was the system's firewall. I also found some supports on the websites 'www.support.microsoft.com'. It said that you can set the port 1433 or the sqlservr.exe to the execption. I also do that, but still not works.

Is there any things i forget and how can i solve the problems! Thanks for advances.

View 11 Replies View Related

Does A User Have To Have SQL Server Installed In Order For Windows Form To Connect To SQL 2005 Express DB

Apr 23, 2008

Hello,

I am creating a windows application that is not going to be used in a controlled environment like a LAN or some other network, so I want to include a local database in the install of this app. Ideally, I would like to use SQL 2005 Express like you would MSDE or Access, but I am not sure if the user must have SQL Server installed on their machine in order for this to work and I don't have a machine without it to test on.

Any help on this is greatly appreciated.

Thanks,
Derek

View 1 Replies View Related

How Do I Connect Client Machines To SQL Server 2005 Installed On A Windows 2003 Server

Apr 11, 2008

I am new to SQL server 2005


Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.

I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):

These are two things that I need to facilitate:

1) They want to be able to write queries using Query Designer and run from their PCs.

2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.

3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.

Any suggestions are appreciated, especially with item number 1.

View 9 Replies View Related

Cant Connect To SQL Server Installed In Windows Server 2003

Feb 11, 2005

Hi, im trying to connect to my sql server installed in windows 2003 OS, i always get login failed whenever i run my asp.net application, do i have to setup anything in my local computer to access my database in windows 2003 server? or in IIS maybe? pls help.

View 1 Replies View Related

How To Install Windows Application(C#) With SQLExpress In A System Which Is Having SQLExpress Already?

Jan 19, 2007

Hi All,

I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.

If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.

But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.

Can anybody help me out .

Regards,

Doppalapudi.

View 2 Replies View Related

SQL7 On Windows XP Home

Jul 20, 2005

I just got Visual Studio 6 Enterprise which includes SQL Server7. However, when I try to install SQL7 (Standard Edition ?) onWindows XP Home it only installs the client components and notthe server component. The install routine claims this is becauseof the version of Windows I am using.Now I know that IIS isn't supposed to be installable on WindowsXP Home but it is with a fairly straight forward hack, so what Iwas wondering was is there a way to get SQL7 Standard installedon Windows XP Home (maybe with a similar sort of hack)?Failing that (and assuming the SQL7 in VS6EE is "Standard") doesSQL7 Desktop work on Windows XP Home? If so where can I get it(haven't seen one so far on eBay)?Regards PLST

View 1 Replies View Related

Using Windows Authentication On A Home Network

Mar 17, 2007

Hi everyone,

I€™m quite new to SQL Server so maybe this is an easy question but I haven€™t found the answer after 3+ hours of Googling and experimenting.

I have a simple set up €“ two computers named HELEN and DELORES, both running Win XP Pro, SP2. These machines are connected via a home network and both belong to the same Workgroup. There€™s no Domain involved. HELEN is running SQL Server Express while DELORES is the €śclient€?, running SQL Server Management Studio Express. I am using €śWindows Authentication€? and Named Pipes to allow DELORES to work with the SQL Server Express instance on HELEN.

I have a general understanding of €śWindows Authentication€? and I was hoping someone could fill in the gaps. I realize €śWindows Authentication€? uses the underlying Windows User Accounts on the server to validate incoming connections.

I€™m sometimes having a problem in connecting SQL Server Management Studio Express (running on DELORES) to the SQL Server Express instance (running on HELEN). This problem may be due to a lack of understanding of Windows User Accounts.

I€™ve found that if I use the exact *same* username *and* passwords on both machines, SQL Server Management Studio Express has no problem connecting to HELEN€™s SQL Server Express instance. If I change the username and/or password on only one of the machines, the connection fails. Also, if I keep the usernames the same on both machines but I delete the passwords, the connection fails again.

I realize I can set up a user account on HELEN. Do I then have to set up the same user account (with the same non-blank password) on Delores? So far, this is the method that€™s been successful. Is it possible for me to tell SQL Server Management Studio Express to use a particular account (username/password) when connecting to HELEN via Named Pipes? If so, how is that specified?

I admit to my confusion. Any help would be greatly appreciated.

Robin

View 1 Replies View Related

Windows XP Home Edition And SQL Server

Feb 17, 2008

I am new to servers and when I try to learn about them I get confused, because the information does not list a server in XP, but they keep it separate from Microsoft SQL Server, like XP has it's own server. Can someone help clarify for me what the versions of SQL servers are?

SQL 2000 1.0, SQL 2002, SQL 2003........?

View 10 Replies View Related

Using Windows Authentication On A Home Network

Mar 17, 2007

Hi everyone,

I€™m quite new to SQL Server so maybe this is an easy question but I haven€™t found the answer after 3+ hours of Googling and experimenting.

I have a simple set up €“ two computers named HELEN and DELORES, both running Win XP Pro, SP2. These machines are connected via a home network and both belong to the same Workgroup. There€™s no Domain involved. HELEN is running SQL Server Express while DELORES is the €śclient€?, running SQL Server Management Studio Express. I am using €śWindows Authentication€? and Named Pipes to allow DELORES to work with the SQL Server Express instance on HELEN.

I have a general understanding of €śWindows Authentication€? and I was hoping someone could fill in the gaps. I realize €śWindows Authentication€? uses the underlying Windows User Accounts on the server to validate incoming connections.

I€™m sometimes having a problem in connecting SQL Server Management Studio Express (running on DELORES) to the SQL Server Express instance (running on HELEN). This problem may be due to a lack of understanding of Windows User Accounts.

I€™ve found that if I use the exact *same* username *and* passwords on both machines, SQL Server Management Studio Express has no problem connecting to HELEN€™s SQL Server Express instance. If I change the username and/or password on only one of the machines, however, the connection fails. Also, if I keep the usernames the same on both machines but I delete the passwords, the connection fails again.

I realize I can set up a user account on HELEN. Do I then have to set up the same user account (with the same non-blank password) on Delores? So far, this is the method that€™s been successful. Is it possible for me to tell SQL Server Management Studio Express to use a particular account (username/password) when connecting to HELEN via Named Pipes? If so, how is that specified?

I admit to my confusion. Any help would be greatly appreciated.

Robin

View 6 Replies View Related

Connect To CE Remotely

Jun 8, 2007

If I have SQL 2005 Standard installed on a server and I log on locally to that server. Can I connect to other machines through Management Studio-->Object Explorer that have SQLCE installed and manage the CE DB?



I think you can only connect to either local .sdf files or ones located on a device attached by USB to the local machine, but I have had some difficulty finding a definitive statement on that.



Thanks

View 1 Replies View Related

Sql Server 2000 And Windows Xp Home Edittion

Jul 20, 2005

Ive seen several sellers, both retail and on ebay, who say that sql server2000 developeredition will run on windows xp home edition. Is this true? Some articlesI've seen imply yeswhile other articles imply no. I'm trying to learn sql server and a lot ofbooks I've purchaseoffer a 120 day evaluation. I'd prefer to buy an edition that I can affordand will give me boththe server and tools.A seller on ebay is selling the developer edition and it's price is withinmy budget. I don't wantto buy it if it won't install on windows xp home.Any help would be great. Thanks

View 1 Replies View Related

Cannot Remotely Login To SQL Express Since Last Windows Update

Nov 17, 2006

Since today (after installing the latest Windows Updates !on my local machine!) I cannot login to a SQLExpress instance remotely; stating that it cannot find the server/instance.


The weird thing is: it only happens when I want to login to the non-default instance (sqlexpress 2005) (<IP><instance>).

When i'm using the default instance (msde 2000 or sqlexpress 2005 on another machine) (<IP>) it seems to work fine.


Does this have something to do with the windows updates, or is it just a coincedence?

Thanks in advance,

Remco Ros

View 4 Replies View Related

Remotely Connect To MSDE

Dec 29, 2003

Hi
I just installed MSDE over my Windows 2003 box and facing an small problem.
I installed it with SQL security mode and also set a password for user "sa".
Everything looks just fine using "osql" as it uses local address.
But I can't connect to my server from another computer using VS.NET Server Explorer.
It seems as MSDE is set to reject connections from outside by default.
My question is how to enable it so I can connect using my "sa" account.
Appreciate your help in advance.

View 3 Replies View Related

Can't Connect Remotely To SQL Server

Dec 30, 2005

I just reinstalled SQL Server and after reattaching my databases, I can't connect remotely. If I use "localhost" in my connection string it works fine, but I can't register my remote Enterprise Manager this way.

View 1 Replies View Related

How To Connect To Sql Server Remotely

Mar 16, 2008

Hi everyone,

I'm trying to connect to my instance of SQL server 2000 remotely. I know how to do this with SQL server 2005. but since i do not have SQL server 2000 installed on my local machine.. (xp box) I would love to know how i can connect to my remote server?

Is this at all possible without SQL Server 2000 installed ? i have tried to download the personal edition / developer but I couldnt find it

If anyone knows where i can find the developer edition or if there is a trick to get SQL server 2005 to work with my SQL 2000 server it would be greatly appreciated.
thanks

View 1 Replies View Related

Unable To Remotely Connect To SQL Exp

Aug 11, 2007

I have both the develper and sql express installed on my laptop computer. I also have Sql Express installed on my desktop computer( Did have develper installed but removed thinking the problem was in the install). I can connect via Management console from my Desktop to laptop with out any problems. I see databases etc. I can not connect from my laptop to desktop. I get a login error. From what I can tell, the servers are configed the same on both machines. I checked Firewall settings on both machines, even turned them both off with no results. Every time I try to connect from laptop I get Log in error, and I get "Failure Audit" eror under component services.

Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 11-Aug-07
Time: 07:24:50
User: LARRY-GATLINGuest
Computer: LARRY-GATLIN
Description:
Login failed for user 'LARRY-GATLINGuest'. [CLIENT: 192.168.1.102]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 18 00 00 00 4c 00 41 00 ....L.A.
0010: 52 00 52 00 59 00 2d 00 R.R.Y.-.
0018: 47 00 41 00 54 00 4c 00 G.A.T.L.
0020: 49 00 4e 00 5c 00 53 00 I.N..S.
0028: 51 00 4c 00 45 00 58 00 Q.L.E.X.
0030: 50 00 52 00 45 00 53 00 P.R.E.S.
0038: 53 00 00 00 07 00 00 00 S.......
0040: 6d 00 61 00 73 00 74 00 m.a.s.t.
0048: 65 00 72 00 00 00 e.r...


I am at a loss as to what is wrong. I am migrating my Database apps to Sql from Access and need to access remotely and locally, as well as do Replication. Any ideas?

Thanks
Larry Gatlin

View 12 Replies View Related

Cannot Connect To SQL Express Remotely

May 18, 2005

I have SQL Express April CTP (from VS Beta 2) installed on machineA, but I cannot connect to it from machineB using the command "sqlcmd -S machineAsqlexpress -E".  This command works just fine from machineA.

View 7 Replies View Related

SQL Server 2005 And MS Windows Vista Home Edition

Dec 26, 2007

hi,

Can we install SQL Server 2005 on MS Windows Vista Home Edition???

Please guide..

Thanks

View 4 Replies View Related

Sql Server Express Edition Installation (OS Windows Home XP)

Mar 8, 2006

Hi,

I am trying to install SQL Express on Window Home XP and SCC is returning the following error:

The SQL Server Configuration Checker cannot b execute due to WMI configuration on the machine ..... Error 2147942405 (0X80070005).

I tried running the following batch file which I believe resolved the same issue that someone else raised earlier (though I am not sure whether the OS was Home XP)

Will upgrading from XP Home to XP Professional (academic version) help me install SQL express successfully>

The Batch file I ran looks like this:

FIXWMI.CMD
------------------------

@echo on
cd /d c: emp
if not exist %windir%system32wbem goto TryInstall
cd /d %windir%system32wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End

:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /RegServer

:SkipSrv
goto End

:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End

Any suggesstions will be geatly appreciated.



View 4 Replies View Related

Confused About Whether I Need .Net Framework 2.0 With Windows Vista Home Edition!

Dec 4, 2007



I wanted to install SQL Server 2005 Express Edition, instead of installing .Net Framework 2.0, I installed .Net Framework 3.5. When I tried to install SQL Server 2005 Express Edition I received the following error:

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=2, native_error=7404, msg=[Microsoft][SQL Native Client][SQL Server]The server could not load DCOM.
Error Code: 0x80071cec (7404)
Windows Error Text: Source File Name: libodbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@sysdbupg.sql@56
Source Line Number: 91

I then decided maybe I do need .net framework 2.0, but when I try to install it it says it's already included with the OS.

But the "Programs and Featuers" only list .Net Framework 1.1 and .Net Framework 1,1 Hotfix (KB92979).

I uninstalled .Net Framework 3.5 and tried to install .Net Framework 2.0 again, but it still says it's included in the OS.

After uninstalling .Net Framework 3.5, I tried to install SQL Server 2005 Express Edition, but still received the above error message.

Is .Net Framework 2.0 included with Windows Vista Home Edition?

If it is, any ideas in solving the Server 2005 Express Edition installation error?

Thanks in advance for your help!

View 2 Replies View Related

Sql Express Error 18452 : Windows XP HOME Problem

Nov 19, 2007



Hi Experts,
Can anyone help me to identify the problem? The situation of my problem is : My company network in clients side is running either Window XP Pro or Window Xp Home.The problem occur when i access from Window XP Home to Server (Window Server 2003) an error pop up Sql Express Error 18452. It is worked fine in WIndow XP Pro version.
Thanks for anyone provide me a solution.

View 15 Replies View Related

Error When Installed Sql Server 2005 On Vista Home Premium (WMI Error)

Oct 8, 2007

Hi. I've been trying to install Sql Server 2005 express on Vista Home Premium. After the initial files install, I get an error message that says the WMI configuration is not correct. (I'm not at home, so I can't post the exact error code at the moment). Does anyone have any ideas on how I can fix this? Thanks in advance.

View 3 Replies View Related

Connecting To SQL Server 2005 Remotely Via Windows Authentication

Oct 20, 2006

Hi

I have installed SQL Server 2005 onto a server and then on my client machine I have installed SQL Server 2005 and the Server Management Studio.

When installing it on the server I chose all the defaults so have not setup an sql username or password to connect as I thought I could use Windows.

I go to the Server Management and registered servers, create a new one and enter the ip address of the server and choose Windows Authentication. The following error keeps appearing though and I am not sure what settings/where to check:

Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)


I have checked and think port 1443 is open on the server, tcpip is enabled but when I choose Windows authentication I cannot enter a username or password as it is greyed out. It has completed the username but no password and these are not the correct ones to connect to the server - I wish to wish the same one I use for RDC.

Or should I try SQL Authentication and if so how would I set this up? Cannot see on the server in SQL Configuration where I could set this?

Hope someone who knows a lot more than me on this can help!

Thanks for your time - this has been driving me mad for days now and everything I print off the internet is not help so any feed back or more useful links to loo up would be great.



View 4 Replies View Related

Cannot Connect Remotely To HTTP EndPoint

Feb 1, 2007

Dear all,

I appologise that incarnations of this topic have been posted several times on this forum, however I cannot find a scenario that is the same as my own so I've resorted to starting a new thread.

I can successfully create and connect remotely to an HTTP EndPoint on my Windows 2003 machine using Integrated security, the administrator username and password via my static IP address.

I have read that Windows XP SP2 supports HTTP EndPoints, and it would be much more convenient for me to be able to create EndPoints in XP, and connect remotely.

I have created the endpoint like so...

CREATE ENDPOINT sql_tvr10
STATE = STARTED
AS HTTP(
PATH = '/sql/tvr10', AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR))

FOR SOAP (
WEBMETHOD 'StoredProcedure1'
(name='master.dbo.StoredProcedure1'),
WSDL = DEFAULT,
BATCHES = ENABLED,
DATABASE = 'master',
NAMESPACE = 'http://194.106.11.11/' )


In visual studio I can retrive a list of services running at http://localhost/sql/tvr10?WSDL absolutely fine. However, in Visual Studio on the remote machine, I cannot connect to http://194.106.11.11/sql/tvr10?WSDL - it prompts me for a username and password, however I cannot select the username - it is set to "Athlon64Guest" (Athlon64 is my server computer name). I have no passwords on any of my windows accounts (except administrator), and I have no database passwords set.


Could someone please tell me how I should go about accessing the HTTP EndPoint?

Just so it is clear, I am running a small LAN with no domain, just a workgroup. I need the client application to be able to connect via http regardless of which network it is on. I am using VS2005 and SQL Server 2005 Dev Ed.

Many thanks in advance,
Simon

View 12 Replies View Related

How To Remotely Connect To SQL Express Using SQL Authentification Across A LAN.

Sep 19, 2007

I hope helps some folks. I hope the links come through okay.
Keywords: Help, Network, KB910437, SQL Express, Network, TCP/IP, User,



SQL Server Express Networking

After a long period of trial and error I finally figured out how to connect to SQL Server Express 2005 using SQL Authentication across an XP network. It required several rather involved several steps to do this. I wrote this document just in case I forgot what I did so that I could repair or re-create my network login(s).

I will try to summarize the steps and include some HELP links to the web pages or my local €śSQL Books On Line€? pages that pointed me in the correct directions. The final piece to my puzzle was found here on the MSDN forums. Some links are better than others, while others may appear not to apply, so always check for links at the bottom of pages. Some were the best I could find after the fact, and not my original pages. Others were actually better, and may seem to be redundant. It€™s a work in progress.

I left out many routine or obvious steps like telling you when to click OK. If you need to be told when, you have no business even considering trying this. Good Luck!


PREREQUISITES:

1. You must have an instance of SQL Express installed and running.
2. You must have the SQL Browser service running.
3. You must have SQL Management Studio Express, SMSE, installed on your Server and to be able to log in as an administrator using Windows Authentification. Be familiar with Object Explorer under SMSE.
4. You must have SQL Server Surface Area Configuration properly installed.
5. You must have a functioning LAN, such as a Windows Workgroup.
6. You need a second computer on your LAN running SMSE Tools for testing.
7. You need a strong knowledge of how to use Control Panel.
8. You need to have KB910437 properly installed despite what this might say, although a neat diagnostic command is documented to verify your install.


SUMMARY:


You must enable SQL Networking
You must configure SQL TCP/IP for the server instance.
You must configure the server instance to use UDP Port 1433.
You must enable a UDP port in your Windows Firewall for that server instance.
Test the ability to remote log in using Windows Authentification using SMSE.
You must create a Windows User account for SQL.
You must create a SQL User login Auditing for that Windows User account.
You must grant Permissions to do things for that SQL login.
Now you can try to Log In across a network.


DETAILS:


SQL Networking must be setup by using the SQL Configuration Manager, SCM.

The default installation leaves networking disabled.
Select and use the TCP/IP protocol.
Re-Start the SQL Server service.
Using the SQL Server Surface Area Configuration Manager you must enable TCP/IP.

Select €śServices and Connections€?.
Choose your server instance and then select €śRemote Connections€?.
Choose €śLocal and Remote€?, then €śUsing TCP/IP Only€?.
Re-Start the SQL Server service.
The server needs a means to talk to the outside world. Use SCM.

Setup your IP address by right clicking on the TCP/IP protocol
Choose €śProperties€?.
On the €śProtocol€? tab leave the default settings, (Yes, 30000, Yes, No).
Select the €śIP Address€? tab.
Configure €śIP1€?, (Yes, Yes, enter your IP address, 0, blank).
Configure €śIP All. Leave the default alone.
Enter €ś1433€? on the second line.
Re-Start the SQL Server service.
The server needs to unlock the door to the outside world.

Open Control Panel and select Windows Firewall.
Click the €śExceptions€? tab and click on €śAdd Port€¦€?.
For €śName€?, enter the name of the server instance.
For €śPort Number€?, the same port as Step 3, 1433.
Test to see if Windows log in works before enabling SQL Authentification.

Using the SMSE, select the €śConnect€? icon in Object Explorer.
Accept all defaults and see if it works.
The server needs Windows user accounts setup.

Set up a generic user account for SQL remote users.
I suggest setting up an account for administrators to use.
I suggest setting up an account for general users to use.
SQL needs to add Windows users to SQL Logins.

Convert a windows user login to a SQL login manually or automatically.
The user needs to be assigned tasks that he is permitted to perform.

Grant the user limited access, or just enough.
Assign generic logins to groups, and then assign permissions to the groups.
Use the pre-defined groups. By assigning users to groups.
Test to see if SQL Authentification works locally, then remotely.

Using the SMSE, select the €śConnect€? icon in Object Explorer.

View 6 Replies View Related

Use VPN To Connect Remotely To SQL Express Server

Dec 15, 2006

Hello,

I'm using a Windows XP Home laptop to connect to a network of one of my customers. The administrator of the customer has given me a username and password for a VPN connection. I've got the VPN connection working and I can ping the SQL Express server.

This server is using Windows Authentication. For the users of my VB application we have added a group to the Active Directory and added this group as a user to the SQL Express Server. This works and the users can access the database from within the application. The SQL Express Server allows remote connections and the browser service is also running.

I would like to use the SQL management Studio Express on my laptop to access the remote SQL Express server and manage the database files. To do this I first connect to the remote LAN using VPN and add the address of the SQL EXpress server in the field 'Server name' of the 'Connect to server' screen. The authentication field is set to Windows Authentication. However the username is greyed out and states the login for the SQL Express server on my laptop: laptopusername. How can I correct this?

I don't know whether the username of the VPN connection is in the Active Directory. Should this be the case and should this user also be added to the login/user of the SQL Express server? And how do I get the Management Studio to connect to the remote server? Could XP Home be the bottleneck as it cannot logon to a domain?

Anyone any ideas?

















View 2 Replies View Related

Cannot Connect To SQL 2005 Remotely From Vista

Apr 15, 2007

TITLE: Connect to Server
------------------------------

Cannot connect to iiiidddbbb.

------------------------------
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)


------------------------------
What's blocking my remote connection to SQL 2005 on Windows 2003? I am using Vista Ulttima and the above message comes up after I clicked connect. However I have no problem to connect to same database from same location using XP. Can someone help?



View 4 Replies View Related

SQL2005 Developer Install On Windows Vista Home Premium

Feb 19, 2008

Hi, I'm having a problem installing SQL2005 Developer on Windows Vista.

At the System Configuration check page, I'm getting the IIS Feature Requirement item telling me IIS is not installed or disabled. This is not the case.

I have read article http://support.microsoft.com/kb/920201 and switched on the IIS components as specified.

I've tried installing with Firewall, virus checker etc switched off. Every time I get the same problem. This is an issue, as I specifically need Reporting Services installed.

Has anyone managed to solve this problem ?

View 6 Replies View Related

SQL Server 2005 Installation On Windows Vista Home Premium

Mar 8, 2007

Hi Every One,

I am trying to install SQL Server 2005 on Windows Vista Home Premium edition, when I run the Installer I received  are the following error message.

 IIS Feature Requirement (Warning)



Messages

IIS Feature Requirement


Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

I already configure IIS7 with all feature, but system still generate above mentioned message.

View 18 Replies View Related

Cant Connect To SQL Server At Work From Home Project

Mar 6, 2005

HI All,

i have copied a project from work i am working on and have created the same project at home in visual studio.net - everything is the same as it is at my work - for some reason though i cannot connect to the servers from my home project

can anyone help me with this - i get the message "SQL Server does not exist or access denied"

my web config has exactly the same set up with a key in appSettings as

<add key="My_Connection" value="User ID=myID;Password=myPassword;Initial Catalog=myCatalog;Data Source=xx.xx.xx.xx" />

can anyone tell me why i would not be able to even see my work database from home?

thanks in advance

Gilesb

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved