I want access remote server data base for my asp.net application my connectin string is
<add
name ="Constr"
connectionString="Server=xxx.xxx.xx.xxx,xxxSQLEXPRESS;Database=ABC;Integrated
Security=True"/>
and Error is
Login failed for user ''. The user is not associated with a trusted SQL Server connection. there is not any user id and password for access data base i already tried Uid=sa;password=sa
My asp.net 2.0 is deployed in web hosting.. now here in my server i have configure a static ip.. so how to access my ms sql database all over the world.. i need to know is that i need to write directly connection string in a webconfig of my static ip.. or i need to create a instance of my static ip to ms sql server 2005 to access the database..
View 7 RepliesHow to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
try to provide solution.I am developing one web application using Asp.net 3.5 and C#.net 3.5.in my application i have to read files(Flat files stored in folder) in remote server which is located at another location.how to do that.now i can read &retrieve from local area.
i have that server host address,UID and Passwrd also how to access that files from remote server.
I want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) 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)
View 1 RepliesI have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?
View 6 RepliesI need to insert a record in table which is in remote server....I am using two connection strings for local and remote....both the servers are in same workgroup only...so am able to connect the both.The problem is am filling data of local table in on dataset1 and remote server table data in another dataset dataset2..Now whil inserting a record local an error occured like "This row already belongs to another table" after googlingI found like this like "Dataset.importrow()" instead of "dataset.add()" method...then there is no errors but the inserted record is not inserting in remote server database...
View 5 Repliesi want to inser the value in data base ...i am using asp.net in visual studio 2008...i want syntax to insert the datetime,integer ,float,string data type into the data base.
View 3 Repliesi want to insert the value in sql data base.in table id coloum is unique.because of this i cant able to select not null type....so i cant able to insert the value in data base.
View 3 RepliesI am trying to make a small utility program to update a table in a database.
I made it as a asp.net 2008 project and connected to the development SQL server(which is located locally).It is working fine.
Then I try to move this to production, I realized that the sql server is located in another state and I can not connect it this way.( connection string from webconfig and open the connection).I can not change any configuration of the prod sqlserver.
I get error like sql server does not accept remote connection.( Verify that SQL Server is configured to allow remote connections).
I am trying to make a small utility program to update a table in a database.
I made it as a asp.net 2008 project and connected to the development SQL server(which is located locally).It is working fine.
Then I try to move this to production, I realized that the sql server is located in another state and I can not connect it this way.( connection string from webconfig and open the connection).I can not change any configuration of the prod sqlserver.
I get error like sql server does not accept remote connection.( Verify that SQL Server is configured to allow remote connections).
how check connection with data base? Now I all query put in try and catch. But I need to check only is access to data base
View 1 RepliesI have a 1.5 GB file into a table. I want to read It from server and create a file stream with it for save.
When I use DataAdapter.Fill(DataSet); code OutOfMemoryException occurs.
What should I do for read a hage file from data base?
I have a SQL server in my office. I can connect from my home development workstation website to the remote SQL server with no problems but when I upload the site to the web host and try and use the same SQL server it fails with 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible'
View 4 RepliesI am in need to retrieve data from data base and display a field based on the drop down is selected
View 2 RepliesI want to grab some values with a form and then do a lookup via a datareader in a data access class (N-Tier).
I want to return a data list and bind that to a form view control.
Here is some code from the DAL, Business object and search form.
The parameterized query doesn't like the data being passed to it from my web page .
[code]....
[Code]....
Where is the nvarchar size of 4000 coming from ?
I have an ASP.NET MVC site that is running into some conditions that it is pegging the processor on the iss boxes it's running on. I don't have access to these servers (it's a farm of about 5 iis6 boxes behind a netscalar). I am doing some logging to a sql database, but the problem is that when the cpu pegs my database starts timing out. The iis servers are hosted in house, but I can't get access to them.
And to make things ever more complicated, I can't reproduce any of these issues in my qa environment (which I don't have access to either). QA is setup to similarly to our prod environment, but it runs on a single box that isn't behind a netscalar.
We have staging server and production server for website. We will move the changes from the staging server to the Production server through the FTP.
Since we have the product release for every 3 months. So, we need to redirect to the latest version in the Production server IIS. Is it possible to access the Production server IIS and redirect the web site link from staging server ?
how to add web service which is deployed in remote server. externally i unable to access that service..in that remote server only that service will run but we don't have Ms.net Environment to add service to my application in that server. how to add that web service to my application ,not accessig externally that service URl, internally Executing that URl. How can i add that service to my application on my developer PC ?
View 2 RepliesI have 2 machines on a domain. The first machine has IIS 6. 0 inatalled on it, whereas the second machine has published web content.
On the local machine ie. Web server i have configured the website like "A Share located on another computer" Eg: //Machine2/Application1. The pubished web content is inside a shared folder on the remote machine. Finally when i run the application in browser(IE 7.0) i get the following error.
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. review this log entry to discover what caused this error to occur.
The Error in the Windows event viewer is as follows:
[COde]....
writing a web Service and one of its web method, I want it to download a png file in form
of buffer from remote server. And My consume application will write that buffer retured by Web service in to file on User's Computer.
However, I am able to do this using Local Web Service but when I published that service on my web server, I always get null retuned
And even in one of my test code while copying file from that server , I always get Access Denied.
Following things I have done for above issue.
1] I even tried making the Anonymous user for the web service the system administrator (with the correct password), to no avail.
2] I also tried sharing out the folder I'm pulling files from to allow access from Everyone.
[Previously same service was working fine on another remote server with IIS 7.0, we checked server IIS Settings but in vain.]
if you know where we are mistaken guide me to resolve this issue as its very urgent.
We have a cient we are stting up that has 2 separate physical servers, one that is the web server the other the database server. Using impersonation we have been able to get the website to connect and retrieve data from the sql server so that part is not an issue. The problem is I have a windows service application that must be installed on the web server (as it process files downloaded to an ftp site) and it must be able to connect and write to the sql server as well.We tried adding a system.web block with the impersonation stuff to the app.config file which of course did not work. Can anyone tell me what/how we need to configure this properly?
View 7 Replieshow can i do this thing, because i am designing a web page regarding this thing, i have a n option that send group mail, so that i have to get the users into a group by users selection, and send a single mail to all of them
View 4 RepliesI am having the following code which read all file names from local machine and write them in text file. I need to read File Names from Remote Server.
StreamWriter objsw = new StreamWriter("C:log.txt",true);
public void ReadAllFiles()
{
[Code].....
i could write a query and i could debug forms using both sql server 2008 and visual studio 2008,but i could not connect to the sql server 2008 and test could not be succeded
View 2 Replies