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


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

How can connect Sqlserver 2000 over internet

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

Dear All

i need all of you help me. i want to conect sql server over internet from 1 country to other country using vb 6.

if can please show in example code?

 

thank for your help.

 




View Complete Post


More Related Resource Links

Problem with MOM using DMO to connect to SQL 2000 instance

  
Since the bank holiday weekend the following error message have been generated in MOM The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running. I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues and now I have the following error appearing: The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors  

XML data type in SQLSERVER 2000 for querying

  
Hello,   we’ve developed an application that uses a database with a XML data type column. It works fine with SQLSERVER 2005 an above, but we cannot create the structure in SQLSERVER 2000 because it doesn’t support that data type.   We’ve made some test with SQLXML 3.0 packet and SQLSERVER 2000 but it only adds pseudo-support to work with XML documents. We need to store XML documents into a column and then make selects using XPath sentences over that column. For instance: select * from users where description.exist('//info[@value = "francesc"]') = 1 Is there any way to achieve this using SQLSERVER 2000?? Thanks in advance! Francesc

Cannot Connect SQLServer 2008 with the provider SQLNCLI... Is there any SQL Server 2008 patch to sup

  
We have a program which developed under SQL Server 2005. In the program the provider of the connect string is hard coded as "SQLNCLI". It's ok running on SQL Server 2005. Now, for some reasons, this program must run under SQL Server 2008 (x64). But our program cannot access the SQL Server. We check the reason, found that, in SQL Server 2008, SQLNCLI is changed to SQLNCLI10, this caused our program cannot run. So I want to ask, is there any patch of SQL2008, so that the legacy program can normal access SQLserver with SQLNCLI WITHOUT rebuild a new version?  

SQLServer Express 2008 R2 - Cannot connect Error: 18456, Severity: 14, State: 11.

  
I have just installed  running MSSQL Server 2008 R2 (Express), along with Visual Web Developer 2010 Express In SQL Server Configuration Manager I can see the SQL Server Service running (SQLEXPRESS) and the SQL Server Browser service running. On running SQL Server Management Studio when trying to log on I get the message Login failed for user Phil-PC`Phil (Microsoft SQL Server, Error: 18456) In the SQL Server Error log I see this error 2010-09-16 10:24:16.07 Logon       Error: 18456, Severity: 14, State: 11. 2010-09-16 10:24:16.07 Logon       Login failed for user 'Phil-PC\Phil'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>] I have been unable to find anything useful on Google on how to resolve this problem. I have tried running the command line utility sqlcmd -L and this lists the following Servers:     Phil-PC     Phil-PC\SQLEXPRESS   In my list of Installed programs in Control Panel I see both MS SQL Server 2008 & MS SQL Server 2008 R2, is that correct?

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

  
Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

Visual Studio won't connect to SQL 2000

  

Can VS 2010 connect to a SQL 2000 database?

I get this error while using the Data/Connect and SQL Server 2008 R2 comes up.


"The connection failed because this instance of SQL Server is not supported. The Editor cannot connect to SQL Server 2000 or earlier

versions."


Our production server is on SQL 2000


SQLServer/anydb connections over the internet?

  

 

Are there any canned approaches to expose a database connection over the internet? I don't mean how to go about opening ports on firewalls to access database as if it was on the local LAN(already know how to ).  I also don't mean expose specific data like through a web service. The basic idea is to connect to something like a webservice url for example http://aa.aaa.com/con.db and i would have access to the same things i would have access to as if i made a local connection object with a connect string, access to all tables, stored procedures, execute queries etc. 

I would appreciate it if someone could point me in the right direction

TIA

How to create linked Server to connect from SQL Server 2008 to SQL Server 2000

  

How to create linked Server to connect from SQL Server 2008 to SQL Server 2000.

I following the steps to create the linked server in the GUI but failed with the following error message.

I used the full computer network name as the 'Linked Server' name

 OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "my_server_network_name". The provider supports the interface, but returns a failure code when it is used.

Thanks a lot for your help.

Tom


unable to connect to sqlserver while creating my account using VS2010 proffessional in WIN 7 home pr

  

Hi,

I am getting  an error while  debug my application that unable to connect SQL server......The message is...

 

 at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
   at System.Web.Security.SqlRoleProvider.RoleExists(String roleName)
   at System.Web.Security.Roles.RoleExists(String roleName)
   at BusinessApplication4.Web.UserRegistrationService.CreateUser(RegistrationData user, String password) in C:\Users\Balakrishna\documents\visual studio 2010\Projects\BusinessApplication4\BusinessApplication4.Web\Services\UserRegistrationService.cs:line 51
   at CreateUser(DomainService , Object[] )
   at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
   at System.ServiceModel.DomainServices.Server.DomainService.Invoke(InvokeDescription invokeDescription, IEnumerable`1& validationErrors)
   at System.

Connect to sql server 2008 remotely via internet

  

Hey'a guys kinda new in sql server..

Im developing a C# windows application.

I want to connect to my sql server remotely outside our local area network. Basically I want to connect through the internet. can I do that? How? through terminal services? any reference on how to install/ setup terminal services on my windows server..?

What could be the best connection string for that matter that I can use for my ADO.net?

my connection string is:

@"Network Library = dbnmpntw; Server =  "servername\domain name,1433" ; DataBase = "databasename" ; User ID = "username " ; Password = "password ";

Ive tried going to connectionstrings.com but couldnt find one that works over the net.

Do I have to add the static Ip in my connection string?

When connecting through LAN everthing works fine. Problem happens when i try to connect outside our office.

I think maybe the problem is in my connection string....

"server was not found or was not accessible"


How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.

  

how to write SMO's conn.ConnectionString with IP address and port?


When i connect SqlServer db i got The specified network name is no longer available.

  

 

Hi.

 i got an error when i connect to sqlserver 2005 db with use of Sqlserver ManagementStudio.

 

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)(Microsoft Sql Error - 64)...

 

 


connect 2 different database in stored procedure over the internet

  

Hi,

i have two data base in two sql server instance and different computers and different places over the internet.

I can create a stored procedure that does a select of a table from a database of a computer, and then insert the table in another database of another computer?

example:

SELECT * FROM SERVER1.DATABASE1.dbo.TABLE1

after prepare and insert in the other computer, SERVER2.DATABASE2.dbo.TABLE2

 

its possible?

 

thanks in advanced



Connect to database over the internet...

  

Hey.

 

I am using Windows 7 and did install the MySQL ODBC connector a few days ago.


What I am trying: I´d like to connect to my remote database named "database" on the server "data.base.com" with a username and a password.

 

My Problem is, that I don´t know how create the connection string for a DSN on a server not in my intranet.

Any hints, suggestions, etc?

 

With Regards,

-Inc


Script SQLServer - 2000 database

  

Hi Gurus,

I need your advice, how to go about the following task which i need to do

1) Create SQLSERVER 2000 database creation script. This will have script for all objects in database.

2) Update the header of each sql files based on the template provided.

for task 1 i can create the sql scripts using enterpirse console for sqlserver. Database have lot of indexes and table. how to find the logical sequence the sql scripts(with out hit and trial) ?

for task 2 do you know any documentaion utility  which can apply header template to each database object sql script ?

thanks

 

 


If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Rajender Saini Aditi Enterprise Solutions - Partnering Innovation | www.aditi.com

how to connect PHP with SQLSERVER 2008

  
how to connect PHP with SQLSERVER 2008

unable to connect SQLserver 2008 to (local) on windows 7

  

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

Cannot connect to (local).

------------------------------
ADDITIONAL INFORMATION:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)


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