Connecting To External SQL DB?

Jan 10, 2008

I'm trying to develop an application for a friend, who has his own server and SQL 2005 setup on it

Is it possible to add a connection to an externally hosted SQL Database using VWD2008?  I have a login and password for it, I just don't know where I set the IP address to connect to and the name of the DB etc...?

Any help greatly appreciated. 

View 3 Replies


ADVERTISEMENT

Connecting To External DB

Oct 17, 2005

hi,am working with my friend so we need to use the same DB ..how can i get him DB and insert it in mine to use it.i 've try to copy it and paste in C:Program FilesMicrosoft SQL ServerMSSQLData then try to connect it by New connection bt it doesn't workNote:am working n Web Matrix ProjectRegards,  

View 3 Replies View Related

Connecting To An External Server

Jun 9, 2004

Hi,
I have been developing an app using SQL Server 2000 and am ready to transfer to a server located offsite. How can I connect to this server through enterprise manager or anything else so that I can use the copydatabase wizard to move it to the live server?

Thanks

Wheelz

View 4 Replies View Related

Problem Connecting To External SQL Server

Jan 24, 2007

Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem...

I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy!? Well not for me ..

This is the error
Microsoft OLE DB Provider for SQL Server[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight off no changes...

After some investigating I have found a few threads about advice but still cannot get it to connect to the external SQL DB (BTW I can connect to a SQL DB on my server its just externally)... This is what I have done / Checked so far..

I have changed the connection string to include the port number 1433
(Provider=sqloledb;Data Source=THEIPADDRESS,1433;Initial Catalog=DB;User ID=xxxxx;Password=xxxx;)

I can ping the IP address of the external SQL Server with no problems

On my server I have enabled TCP/IP in SQLExpress & added sqlservr.exe as an exception in the Firewall

I have even tried turning the Firewall off completely while I tried to connect - But still nothing.

If anyone can help me I would be very appreciated.... I am starting to tear my hair out as I can't think what else I need to do???

Thanks

View 5 Replies View Related

Connecting To An External SQL 2000 Server From A Vista Machine With SQL 2005 Installed

Nov 26, 2006

hi there - I'm praying someone here can shed some light on this - after many google and web searches, I have found users with similar issues, but have yet to find a solution.
Problem: I have recently upgraded my desktop from Windows XP to Windows Vista Ultimate (clean install) and have migrated my local machine to SQL Server 2005. However I have a number of .Net projects that access databased on another server running SQL Server 2000 - prior to my upgrade to Vista, I was running SQL Server 2000 on my desktop as well. During the install, everything seemed to go well, and I also installed the SQL Server 2005 Service pack as instructed via the MSDN site.  However, when attempting to test my .net projects on my desktop pc (ie visit http://localhost), I encounter the error:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 note that the server I am attempting to connect TO is the old SQL 2000 server - NOT 2005.  I specify my connection info in the web.config - and it points to an external ip address on the web.
Can anyone shed some light on this?  I've tried enabling remote access on my local SQL 2005 install, but I'm fairly sure thats for servers that want to connect to my desktop, rather than my desktop attempting to connect to external servers. Any help is greatly appreciated - I'm pulling my hair out over trying to figure this out! :)
 To summarize my setup (if it helps)
Desktop PC:Windows Vista (Ultimate)SQL Server 2005Visual Studio 2005II 7.0.Net 2.0 (ASP.Net Application)
External Server (co-located at a datacenter)Windows Server 2003SQL Server 2000IIS 6.0.Net 2.0 (ASP.Net Application)
 
 Much appreciated,
Ted
 

View 5 Replies View Related

Run External File

Mar 25, 2001

For every one


Visual basic permit use shell command to execute any file
shell "c:programs Filesword.exe
How could I make it in SQLServer 7.0

Sincerely.
Fain Boris.

View 2 Replies View Related

Connect To SQL Through External IP

Feb 20, 2007

have setup SQL 6.5 on a machine. I have verified that port 1433 is opened for SQL. I am also using a router dell 2300. I am running Windows XP.
I have set up my machine to port forward and have setup a static ip 192.168.2.136 nothing I do seems to work.

I can connect to the server by name

ex:
MyStr = "Provider=sqloledb;Data Source=MYSQLPC,1433;Network Library=DBMSSOCN;Initial Catalog=master;User ID=myusername;Password=password;"

Conn.open MyStr

I can also connect using internal IP address

ex:
MyStr = "Provider=sqloledb;Data Source=192.168.2.136,1433;Network Library=DBMSSOCN;Initial Catalog=master;User ID=username;Password=password;"

Conn.open MyStr

but when I try to connect to the external IP 12.xxx.xxx.xxx
I get the dreaded sql does not exist error.

I can register the server by external ip. When I try to start the server I get an (RPC server unavailable) error.

I can ping the external ip.

I can telnet 192.168.2.136 1433 without error

I can connect though security manager using 12.xxx.xx.xx

I can't telnet 12.xxx.xx.xx.

I think its router but I do not know what I'm missing. I have static ip 192.68.136 set up.

Router Port Forward Settings

Service Enabled In Port Dest Addy Dest Port Type
MSSQLSER Y 1433-1434 192.168.2.136 1433-1433 TCP
MSSQLSER Y 1434-1434 192.168.2.136 1434-1434 UDP

I have also read that some ISP's block port 1433 due to the worm problem. So I changed the listining port from 1433 to 1971. I am still able to connect using this new port with local ip or local name. I still cannot connect to external IP. (I did change router setting to reflect new port forward to 1971)


I am not sure what I missing.
Thanks in advance for any help


Chris

View 1 Replies View Related

External Access

Jul 23, 2005

Hello,I want to access my database server from the internet. I've created a ruleon my router to redirect port 1433 to the desired machine, but still get aServer does not exist, or access denied message. When I change the(external) ip to the local IP address, connection succeeds. Is thereanything i need to change within SQL Server to allow external (internet)access?

View 2 Replies View Related

External File In Rdl

Jan 15, 2008



Can I include an external file (html) in report's definition? Like a subreport, and expecting show the file content...

thanks

View 5 Replies View Related

External Connections

Oct 15, 2007

Hi Experts,

I am looking for some guidance on the following CE based project. The project would mean placing a program on multiple appliances (either PDA mrtphone) which would then periodically connect onto a SQL 2005 server and both read and right to a table on the server. This would mean multiple connections to the server.

I have read various articles which discuss the use of SQL_ce to achieve this but SQL_ce is a single user application. Is it possible to achieve this objective by publishing a share of the SQL 2005 database tables to an internet share folder to allow multiple external connections? Also if it is possible can I test the application on a windows XP platform?

Thanks in advance,
Joe

View 1 Replies View Related

External Documentation

Sep 12, 2005

I know that the BI studio can build a nice flow document that is associated with the package.  Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

View 15 Replies View Related

External DataSet On GoDaddy

Jul 13, 2007

Hello,First, I tried to find the answet to this question, but no luck - so I decided to post it.
 When I was creating my applications in asp.net  - for the first time I decided to start using external DataSets. I think they are great and work very nice!But once I pushed the application to GoDaddy, I got an error of this nature:I was trying to access the exterbal dataSet like this:Dim productsAdapter As New NorthwindTableAdapters.ProductsTableAdapter()
Dim products as Northwind.ProductsDataTable...And got an error saying that it couldn't find this type (but it worked fine on my local machine in visual studio).So did I miss something that prevented this application working on GoDaddy? or there are some limitations on GoDaddy? ...or something else.Thank you for looking into this for me.Valera

View 7 Replies View Related

SQL Import From An External Engine

Mar 12, 2004

Hello.
I'm making an application that uses MS SQL as a database engine.
However, I need to read some data found in a DBISAM database.

Can anyone help me how to do this?

I'm trying to use BULK INSERT, but it seems that all the fieldterminators, or rowterminators that i'm trying are not working.


Please help me this is very urgent

View 5 Replies View Related

How Can I Read One External File (*.txt,*.csv) Through

Dec 14, 2001

How can I read one external file (*.txt,*.csv) through
stored procedure in MS Sql Server 2000 ?

On the database Interbase its very simple :

[CREATE TABLE table [EXTERNAL [FILE] ’ <filespec>’]
( <col_def> [, <col_def> | <tconstraint> …]);
EXTERNAL [FILE]“<filespec>
” Declares that data for the table under creation resides
in a table or file outside the database;
<filespec> is the complete file specification of the
external file or table]


Please advice

Thanks


Patricio

View 1 Replies View Related

Restore From External Backups

Jan 29, 2004

Hi everyone,

I have a problem with my MS SQL Server 2000 (SP2). My task is to restore a backup from a database on another computer.

The server makes a backup everyday. If this server gets a hardware problem there must be a chance to replace it by another server which is made by the backup files.

In this scenario I don't have the possibility to copy the whole folder of the old server.

Is it possible to restore the bakup so that the new server looks like the old one?

Thanks for every response.

View 2 Replies View Related

Linking External Tables

May 7, 2004

Hi I am a complete sql newbie :)
With that being said I am trying for the life of me to link to a table in another sql database.

For some reason its not letting me link the table instead it is creating a query of the table.

I used the Access upsizing wizard and the access front end.

*grumbles - just wish I could find the upgrading handbook that tells you if you used to do it this way now do it this way*

Thanks
Sara

View 1 Replies View Related

Calling An External Program

May 19, 2004

Hi,

Is there a stored proc or a function I can call from Query Analyzer to execute another .EXE and return when it's finished?

I'd like something like
SET @RET = sp_CallEXE('c:mypathmyprogram.exe myparameters')

(Except for the name of the function, there should be something that does this right? I mean, DTS does it already so it must be referring to a function or a SP.)

I want an answer to so that I can validate that everything went well (hence the @RET variable)

Thanks,

Skip.

View 1 Replies View Related

Can't Connect To External SQL Server (Please Help)

Jan 24, 2007

Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem...

I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy!? Well not for me ..

This is the error
Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight off no changes...

After some investigating I have found a few threads about advice but still cannot get it to connect to the external SQL DB (BTW I can connect to a SQL DB on my server its just externally)... This is what I have done / Checked so far..

1. I have changed the connection string to include the port number 1433
(Provider=sqloledb;Data Source=THEIPADDRESS,1433;Initial Catalog=DB;User ID=xxxxx;Password=xxxx;)

2. I can ping the IP address of the external SQL Server with no problems

3. On my server I have enabled TCP/IP in SQLExpress & added sqlservr.exe as an exception in the Firewall

4. I have even tried turning the Firewall off completely while I tried to connect - But still nothing.


If anyone can help me I would be very appreciated.... I am starting to tear my hair out as I can't think what else I need to do???

Thanks

View 1 Replies View Related

Database On External Machine

May 11, 2007

Hi,
I have two servers, namely ServerA and ServerB. These two servers are on the same subnet. ServerB has a database called DatabaseB.
I'm logged in in ServerA and trying to pull data from DatabaseB.

This is the query I do when I'm logged in in ServerB (note im using Microsoft SQL Server Management Studio):

USE DatabaseB

SELECT distinct b.Subject
FROM dbo.F_Class_Exam a
LEFT OUTER JOIN dbo.D_Course_Catalog b
ON a.Course_ID = b.Course_ID
WHERE a.Term = '2071' AND a.Class_Exam_Type = 'FIN' AND b.Term = '2071'
ORDER BY b.Subject

How would I do this same query on ServerA? Ideas? Thoughts?

Thanks,
Mikhial

View 7 Replies View Related

Attach To Database On External HD

Aug 21, 2007

I am getting the error
Unable to open the physical file "E:Navision SqlDataForentaSQL_Data.mdf". Operating system error 5: "5(Access is denied.)".
when I try to "attach" to a database located on an external hd. The database files on the external HD were copied from the original server location to the external HD. The file size is 51G+ which is why it is on the external HD.
Can anyone provide me the syntax to do the sp_attach taht will allow me to send the necessary connection string: server, user, pswd etc.

How can I get past this error?

View 1 Replies View Related

Cant Open External Process From CLR

Jan 31, 2008

Hi,



I am trying to print a PDF via a stored procedure in SQL Server 2005 using c#



I first wrote a stand alone version which works perfectly however after porting it into SQL server the program no longer works



Went back to basics and just tried to open notepad from standalone and from within CLR - again works until I put code into SQL Server DB



Trouble is that it seems to run ok - prints lines to console etc... but the notepad application doesnt start up - there are no errors so really struggling to find out why this might be



Anyone have any ideas, had similar issues?? - Only thing I can think of is a permissions/credentials issue of some kind but again dont have any errors???



I have created the dll file and assembly successfully (using unsafe mode)



Thanks in advance



Code sample below:

.

.

.

executable = "notepad.exe";

ProcessStartInfo starter = new ProcessStartInfo(executable, null);

starter.CreateNoWindow = true;

starter.RedirectStandardOutput = true;

starter.UseShellExecute = false;

Process process = new Process();

process.StartInfo = starter;


process.Start();

.

.

.

View 3 Replies View Related

Problem With External Images

Aug 16, 2007

Hi!

I've got a real problem with inserting images into report. The problem is that I work with Reporting Services and SharePoint Portal. My employer wants to have CV created dynamically. Information for CV is taken from database under special account with read-only access. And photos of employees can be found with URL
http://corporate-site/Resources/Team/Name_surname.jpg (this string is also generated dynamically). When I preview report on my local machine, everything is Ok, I can see the images. But when deployed the images are not displayed. I have created an Unattended Report Processing Account to get photos. But if I want to use it I must change account for reading data from Data Source (in my case it is SharePointDB.rds) for €œCredentials are not required€?. And after it I can't get the information for CV.
Does someone know how to use one account for database and another one for getting external image? Or maybe there is another solution for this problem?

Thanks.

Yuliya

View 1 Replies View Related

External Scheduler For Reports

Feb 15, 2007

Hi, here is my problem:
Because of some usability terms, I need to use SSRS scheduler to determine reports creation frequency (minimum frequency is once a day)I need to use an external scheduler to SSRS in order to launch reports creation daily, after some other batch tasks execution that must be completed before launching report creation.
And I have no idea on how to do that properly. Can somebody help me?

Thanks!

View 3 Replies View Related

XML Source And External Configuration

Jan 17, 2006

hi guys,

Is possibile configure as expression the properties XMLData and XMLdataDefinition of a "XML Source"? looking the editors it seems it is not possibile... I think it is a great limit of the component because I must hardcode the path!

Regards,

M.rkino

--
Marco Barzaghi - [MVP - MCP]
http://mvp.support.microsoft.com - http://italy.mvps.org
UGIDotNet - User Group Italiano .NET, http://www.ugidotnet.org
Read my WebLog: http://blogs.ugidotnet.org/markino

View 3 Replies View Related

External Access To SQL Server

Jul 3, 2006

Hello,

I'm not sure whether this is right section to post this. It seems the most relevant one to me. (Please point me in the right direction if it is not).

I am a programmer/web developer for a medium sized organisation in the financial industry (in Australia). Obviously being in the finance industry, we have very strict guidelines and access when it comes to security. We are currently in the process of converting our website to use a SQL Server database (instead of MS Access which we have been using for years). In the past, we have accessed our web database via SFTP as it was only an Access file. Now that we are converting to SQL Server, we will still need access to our database (which is on a server hosted externally). It seems a bit silly (and even bizarre) to me to consider trying to access a SQL Server database via SFTP (as that, to me, defeats the purpose of some of its security features), but is it even possible?

My security guys here will only allow me to access the external server that hosts our website/database via SFTP (on a machine that is outside our network, so any files that I wish to update on our website I need to copy over via USB or whatever). If I am not able to get into the SQL Server administrator program to change our database via SFTP, is there someway that I can "drop" a changed copy of our database into a directory somewhere that SQL Server can "pick up"?

Am I making sense?

Many thanks,

Bronwyn



View 5 Replies View Related

External Linked Servers

Dec 21, 2006

Hi All,
I am doing some research about External Linked Servers and am hoping that someone can point me towards some best practices information and let me know about any gotchas that I should look out for when using this capability in applications.
Thanks in advance,

View 2 Replies View Related

Cannot Register With External Access

Oct 12, 2005

I've done a lot of digging, and I can't find the solution to this one.  I followed Vineet's instructions to get an assembly registered that can call out to Web services; however, when I try to register, I get the following error:

View 5 Replies View Related

Option For Accessing External DLL's From The CLR

May 3, 2006

What are my options for calling external DLL's from SQL CLR, I used to use the sp_OA method but these have been converted to .Net assemblies and I do not want to use interop for several reasons. Any suggestion would be greatly appreciated.



J-

View 5 Replies View Related

Linking To External Tables

Jun 26, 2006

I am trying to create a single query from 2 tables on different SQL servers. In Access 2003 I have been able to accomplish this by created a Linked Table via ODBC connection to a table then create my query reference the linked table.

Is something link this possible with SQL? Any direction would be greatly appriciated!

Scenerio:

Server1

Books

Book_ID
Book_Author
Book_Title
Server2

PurchasedBooks

Customer_ID
Book_ID
vPurchasedBooks (View on Server 2)

Customer_ID
Book_Title (Joined on Book_ID on Server1Books)



View 1 Replies View Related

Using Images From External Link

Apr 25, 2007

Hello,
I tried to use an image from a url and got the error:
"[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access."

I found a link in the MSDN about that that explain how to configure the UnattendedExecutionAccount:
http://msdn2.microsoft.com/en-us/library/ms156302.aspx

But even after I configure it and use my user and password (I'm an admin) I still can't see the images.

Any ideas?
Thanks.

View 4 Replies View Related

Cant Open External Process From CLR

Jan 31, 2008



Hi,


I am trying to print a PDF via a stored procedure in SQL Server 2005 using c#

I first wrote a stand alone version which works perfectly however after porting it into SQL server the program no longer works

Went back to basics and just tried to open notepad from standalone and from within CLR - again works until I put code into SQL Server DB

Trouble is that it seems to run ok - prints lines to console etc... but the notepad application doesnt start up - there are no errors so really struggling to find out why this might be

Anyone have any ideas, had similar issues?? - Only thing I can think of is a permissions/credentials issue of some kind but again dont have any errors???

I have created the dll file and assembly successfully (using unsafe mode)

Thanks in advance

Code sample below:
.
.
.

executable = "notepad.exe";

ProcessStartInfo starter = new ProcessStartInfo(executable, null);

starter.CreateNoWindow = true;

starter.RedirectStandardOutput = true;

starter.UseShellExecute = false;

Process process = new Process();

process.StartInfo = starter;



process.Start();
.
.
.

View 16 Replies View Related

No External Columns Available From SQL Command?

May 9, 2008

Hello.

I have a OLE DB Data Source Component that uses an SQL command as the data access mode. On the Connection Manager "tab" of the OLE DB Source Editor I can sucessfully parse my query and produce a preview of the data.

However, when I go to the Columns tab I see no available external columns? Apart from the fact I'm using a union I can't think of any reason why I can't see any columns, it doesn't make sense.

Please Help.

Thanks

View 7 Replies View Related

Save To External File

Mar 12, 2008

how do i write a select query which will return all my data into an excel file or an xml file or txt file?

View 3 Replies View Related







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