.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Connect to server with other network credentials??

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :ASP.Net

I work from home and need to connect to my employers database server. I am running SQL Server 2008 on my home PC and I am connected remotely to my employers network via vpn. However, if I try to make a connection via windows authentication it's using my credentials I use to log onto my PC and not the credentials I use to connect via vpn. How can I enter my vpn credentials and register the remote server in Server Management Studio?

Thank you...

View Complete Post

More Related Resource Links

local pipes vs. network pipes (to connect to SQL Server)

Choosing a Network Protocol (SQL Server 2008 R2) tells: "It is also important to clarify if you are talking about local pipes or network pipes. If the server application is running locally on the computer that is running an instance of SQL Server, the local Named Pipes protocol is an option. Local named pipes runs in kernel mode and is very fast" Well, it is not me who is talking in cited article, I believe so. Should it be understood that "If the server application is running locally on the computer that is running an instance of SQL Server" and configuring/choosing Named Pipes mean running "local Named Pipes"?

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

Connect Analysis Server across network using ADOMD connection



I'm new to Analysis Server. How will i connect the Remote Analysis Server across Network using ADOMD Connection.


Please Help me!


Unable to connect to sql server in network but working fine over VPN




I have a sql server 2005 named instance running on windows 2003. I have an issue  in sql connectivity:

When the client system is in the network, client is not able to connect in management studio to the SQL server without specifiying the port number i.e. tcp: abc\xyz. If the client specifies the port number, he is able to connect to it like tcp:abc\xyz,20001.

Now the strange thing is : The same client system when connected over vpn works fine without specifying the port number in the connection string  like tcp: abc\xyz,20001.

then why is it failing to get the port number when the system is in the network?

I verified sql browser service. it is running fine. Firewall is in stopped state. What new components would come into picture over vpn that allow browser to service the port number? It's pretty strange issue and hence looking for any thoughts.

Note: SPN is not registered for the sql service.


Cannot connect to SSAS production server in customers network



I have a problem when connecting to the SSAS production server (SQL Server 2008 Standard Edition) of my customer.

The situation is as follows: I have SSMS installed on my computer and also on the production server. On the server the connection to my SSAS/database works fine, but on my machine it doesn't. I am connected through a VPN connection with the customers network. The Windows Firewall is not activated on the Windows Server 2003 SP3 where SSAS is installed on. The connection to the SQL Server Database located on the same server from my machine works fine (via Windows Authentication), but as I said, the connection to SSAS does not. As we have different Windows Domains I am logged on with my corporate login (RCG\alexander.greiner) on my machine and connected through VPN with the administrative credentials (CUSTOMER\myadmin) I got from my customer.

Following error message is displayed when I try to connect to the remote SSAS in my customers network: "A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)"

Do you have any ideas on how I can solve this problem?


how to connect remote sql server on non domain network using SQL Server authentication



i m newbie on sqlserver.I had manage to build a database (MS SQL SERVER 2005 standard) with a vb.net 2008 and tested well with local machine. and wanted to put a software on client. and   some-how manage to stucture a security model on server authentication. but still not clear on user management. and others.

will anybody help me step by step how to connect remote sql server on non domain network using SQL Server authentication


Thanking you advance



Enter your credentials to connect to the web service


When trying to publish an InfoPath 2007 form template (as a Content Type), I am getting the following message with a UserName/Password dialog box:
Enter your credentials to connect to the following web service: http://MySitePath/_vti_bin/Webs.asmx

When I enter my credentials, the above dialog box appears again. I have carefully entered my credential. Another thing I noticed that despite this error I see the form got created at the destination library. The only thing is that the Content Type did not get created and hence is not available in the "Site Content Type Gallery".

We are using Sharepoint 2007 enterprise edition. And I have recently published the InfoPath form templates several time as Content type without any issue.


Please help. Thanks........

send the login credentials from site to another server



  i have a site which uses windows credentials to login and in the site i have link to ssrs server.

when i select the report it asks for authentication which i want to skip and send the same user

crendentials to the ssrsserver to access the report.

can anyone suggest on this..

need help about "Unable to connect to remote server." using HttpWebRequest


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

sqlcmd, cannot connect to server

I have SQL Server installed on a machine called SQLDEV. I log on to that machine and I run the command sqlcmd -s SQLDEV -Q "select * from <db>.<schema>.<some_table> -E This command works and returns a result set.   Next, I go to a different machine. On that machine I can use SQL Mgmt Studio to log on to SQLDEV using window authentication. However, if I run the same command as above, I get some kind of a connection error. The error says, ".... 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 .....   Any suggestions/ideas why I am getting this error?

SQL Server Network Interfaces Error 26 - while failing over SQL Server 2008 R2

Before I explain the issue I am facing, I would like to say that I did read the post at  http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx but in my case the problem is transient (lasts for approximately two minutes after a failover) so items 1-3 in the list of troubleshooting steps do not seem to make sense. As to 4 and 5, the named instances use non-default ports (2433 and 3433 respectively), so I do not know how to tailor the PortQry command for that. I tried  portqry.exe -n ServerA,2433-p UDP -e 1434 and  portqry.exe -n ServerA,2433 -p UDP -e 2434 and it failed both times with a "Failed to resolve name to IP address" while the server was up and serving database requests The same thing happened when I tried it with the failover server as well. ***The issue I am facing*** I am using Enterprise Library 4.1 to connect to a SQL Server 2008 R2 database with a mirror. My connection string itself is as below (with dummy values for all fields): "Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=DBName;User ID=uid;Password=pwd;Connect Timeout=5" Sample .NET code is as below (with modifications to instantiate all variables locally to provide context): SqlDatabase db = new SqlDatabase(ConnectionString); SqlConnection cn = (SqlConnection)db

Unable to Connect to server

I have install sql server 2008 on window 7. But connection to server is failed. These are the options. Sever Type Server Name. Authentication. Login. Pasword. anybody have answer my question????

Install on New Windows7 - Getting Invalid SQL Server Agent credentials

Hi: I have a Developer License for MSSQL Server 2008.  Have just upgraded to Windows 7 Professional Edition.  When installing MS SQL Server, the setup shows that I have an instance of SQL Server Express already installed.  I am given a choice between Default Instance and Named Instance.  First time I chose named instance and then used the name of my machine - RBS1.  I received the following message:  The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service. Went back and tried Default instance and got same answer.  Can't proceed to install.  Any help in this greatly appreciated. roger  

Network failure in Cluster Environment,will it stop the SQL Server Instances?

Hi All I have problem with cluster Environment that is there is network failure in Cluster Environment,will it stop SQL Server Instances Event viewrer Information 6:22:09 The MSSQLSERVER service entered the stopped state. 6:22:05 The MSSQLSERVER service was successfully sent a stop control. 6:22:04 The SQLSERVERAGENT service entered the stopped state. 6:21:43 The node lost communication with cluster node 'MSSQL0002' on network 'LAN'. 6:22:02 The SQLSERVERAGENT service was successfully sent a stop control. 6:22:02 Cluster resource 'SQL IP Address1(SQLCLUSTER)' in Resource Group 'SQL' failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 Cluster network 'LAN' is operational (up). All available server cluster nodes attached to the network can communicate using it. 6:21:58 The interface for cluster node 'MSSQL0002' on network 'LAN' failed. If the condition persist

Cannot connect Visio 2007 to SQL Server CE 3.5 database?

I am trying to reverse engineer a database (running under SQL Server CE 3.5 SP1) with Visio 2007 Professional.  I may be being blind, but I can find not way for Visio to do this.  Am I missing something or just piddling into the wind? Fully patched Vista. Thanks, Ed Bessant  

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend