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


Post New Web Links

Can not connect to SQL 2005 Instances from Client

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
 
Dear Experts I have a problem. I am not able to connect to Remote SQL Server instances from my PC. Though some of my team members are able to connect to the Instances without any problem. We have tried with all the below options and no joy. 1. We tried connecting, with the IP Address, like IP\<ServerInstance>, Port# 2. Added the IP address to Host file with the network address and tried, like <WINServerName>.<networkaddress>\<ServerInstance>, Port#, even without the Port#. 3. Tried to create an ODBC DSN, why this because, this had resolved the issue some times. Thought will help, but didn't work out. After all these, whenever we tried to connect to the server, we received the below error message. Error Message : Can not connect to <WINSERVER>.NetworkAddress\<DBInstance> A network-related or instance-specific error occured 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 :TCP Provider, error:0 - No such Host is known) (Microsoft SQL Server, Error - 11001). Kindly help to resolve this issue. I have been strugling since quite some time. Regard Deepak


View Complete Post


More Related Resource Links

Unable to connect to SQL Server 2005 remotly, all client protocols are blank

  
I have an installation of SQL 2005 and had issues connecting remotly. Looking at the client protocolols, they are all blank. I can see that TCPIP, Named Pipes, VIA, etc. are 'enabled', but where the words 'TCPIP', 'Names Pipes', etc. should be, it's just blank. I tried to install SQL 2008R hoping the Client Protocols would be corrected during the installaion, but they were not. I'm assuming the issue with the Client Protocols not showing up is a symptom of the problem. Does anyone have any ideas? Thanks!

Connect to existing sql 2005 database

  

Hello There,


I had successfully restored sql 2000 database to sql 2005. It works like charm


Now i am creating a database model in MVC


I follow these steps

Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name


But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error

"A network-related or instance-specific error 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.


Kindly help me with this


Regards


SQL-DMO Install on SQL Server 2005 Express Client

  
I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

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 127.0.0.1 & 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!!!

WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7

  
Hi, WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7. With other OS like XP and Windows 2003, client connects to remote DNS properly. I got the following exception. Same client works in Vista and Windows 7 if service is available in local network. Following are the exceptions: <Exception> <ExceptionType>System.ServiceModel.EndpointNotFoundException, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>No DNS entries exist for host icelive.theice.com.</Message> <StackTrace> at System.ServiceModel.Channels.DnsCache.Resolve(String hostName) at System.ServiceModel.Channels.SocketConnectionInitiator.GetIPAddresses(Uri uri) at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.TracingConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.Comm

connect client certificate to an account in a membership database

  
Hello I have created a web service that authenticates with username and password, works fine.Basically this one, http://msdn.microsoft.com/en-us/library/ff649647.aspxNow I also want to connect to this web service using client certificates, works finehttp://msdn.microsoft.com/en-us/library/cc948997.aspx But I would like to when authenticated via client certificates, connect that certificate to a user in the membership database.So that I can use Roles.IsUserInRole(...) and such.I thought that, well if I implement a Custom certificate Validatorhttp://msdn.microsoft.com/en-us/library/ms733806.aspxthen I could check for example subject and map that against a created username in the membership database.But in the class X509CertificateValidatorpublic override void Validate(X509Certificate2 certificate)I don't have the same ability as when the user is authenticatedlike  void OnAuthenticateRequest(object source, EventArgs eventArgs)HttpApplication app = (HttpApplication)source;Basically how can I do this app.Context.User = new GenericPrincipal(new GenericIdentity(username, "Membership Provider"),roles);withinpublic override void Validate(X509Certificate2 certificate)and if that is not possible, can this be solved differently?Bottom line, how do I connect a client certificate to a user account in the membership database. Is there a MSDN article

Connect SQL Server 2005 to Ms Access on another computer

  
I'm trying to create a "Linked Server" on my SQL Server 2005.  This linked server is a reference to an Access File on a remote computer.  I've set up all the permissions and shared resources.  I've created an ODBC DSN to connect to the database.  If i open the DSN in excel, i can retrieve data.  If I open a linked server connected to the DB I get the following error when i try to run a query against it.   ------------------ OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LS_Specialty". ---------------------   Why does this DSN work in Excel and Access, but not in SQL

SQL Server 2005 Express - Does it require a Client Access License (CAL)

  
Do you need a Client Access License (CAL) for each device that will connect to a SQL Server 2005 Express edition database?

Can I have two instances (SQL 2005 - 2008) at the same server?

  
Hello, I have a Windows 2008 R2 with sql server 2005 x64. I would like to have both instances (SQL server 2005 x64 and 2008 x64) at the same server, each one having its own databases. Is the possible? What should I pay attention to? Thank youChristos

How can a C# client app list the authorized CA certificates sent by a web server over an SSL connect

  
Hello, I am currently writting a C# client application that must access a web page over SSL authentication, having the Client authentication required. I know that the SSL protocol defines that the web server sends the list of authorized Certification Authority that the web server can trust for the SLL session to be successful. My client application has to filter a X509Certificate collection in order to popup a Certificate Selection dialog box to the user. I fould like to only display certificates that the web server would accept. I already have filtered the certificates according to the "Client Authentication" Enhanced Key Usage and other stuf. I know how to set the client certificate to be used for SLL conection, but I just would like to access the CA cert list provided by the server.   Could someone help me ? Thanks a lot !

How to connect to MOSS server using visual studio from client side

  
Dear All We are having one moss development environment and we are having many developers working on it.Since all the developers cannot work at a time,we are facing difficulties while developing sharepoint components. Is there any way to connect to sharepoint server from visual studio(from client side) so that we can compile our sharepoint components from client side and deploy later to the server? Any help on this would be much appreciated? Thanks Karthik S

Trouble to connect report on SSAS 2005

  
Hello! I have deployed my first report (ssrs2008) using a ssas (2005) cube as data source but I can't get it to work. I setup the credentials to use Windows Authentication in the SSAS data source and when I open the report from the rs server it renders fine, however when I try it from a workstation I get the error below: The SSRS instance is not on the same server as SSAS. Any Clue? Thanks! Cannot create a connection to data source 'TestCube'. The connection either timed out or was lost. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host

SOS: Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But networ

  
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! System:   Windows Server 2008. Error 18456

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!                                     &

Client using OpenSSL is not able to connect to Server using SslStream.

  

Hello,
I have been trying to get a client written in C++ using OpenSSL 0.9.8a to connect successfully with a server written in C# using the SslStream class in .NET 4.0.  Thus far, I have been not able to get the client to successfully connect and communicate even when my server does not require a client certificate from the client.

I am getting always the following IOException " The handshake failed due to an unexpected packet format. " when i am reaching the AuthenticateAsServe() line in my server.

Any help will be highly appreciated.


Connect VB6 app to SQL server 2005

  

Hi,

I have a VB6 app that has to connect to SQL server 2005 located on another machine.
Now I use a connection string like this

"Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=test1;Network=DBMSSOCN;Server=100.100.100.100;Integrated Security=SSPI"
and it works from my laptop.

The question is, when I move the VB6 app to another machine, what do I need installed there for the same connection string to work?
What stays behind "Provider=SQLOLEDB.1" ?
Is it a single .dll that I only have to put on the other machine and regsvr32 , or it's something more complex?

Thanks


Categories: 
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