SEARCH YOUR SOLUTION HERE  

Getting error to Connect MS-SQL2005 from remote desktop(using public IP address) connection to DotNet windows application



I have a dot net windows application which can be download from the website. I want to use the database for the application by using public IP address. I am not able to connect SQL server 2005 from remote connection it is giving me the error, SQL server does not allow remote connection.

I changed my server remote connection configuration to

Local and remote connection

using both TCP/IP and named pipes

but still i am getting the error.

please help me

Posted On: Monday 19th of November 2012 11:48:40 PM Total Views:  305
View Complete with Replies




Related Messages:

Query string sysntax errors   (144 Views)
I am trying to doa query from php... I am using SQL Server I am trying to get something liek this..where I am usign varaivles for the , = signs These are the variables: varpropertyType = Townhome varPropertyFactor = >, , or
Syntax error converting the varchar value 'SELECT   (147 Views)
hi, I was wondering if some one could help me or check my stored procedure for me, i keep getting this error:- Syntax error converting the varchar value 'SELECT DISTINCT dbo.tbl_Work_Requests.Work_Request_PK, dbo.tbl_Work_Request_Status.Work_Request_Status_Ti tle, dbo.tbl_Line_Of_Business.Line_Of_Business_Name, dbo.tbl_Work_Requests.Work_Request_Number, dbo.tbl_Work_Requests.Work_Request_Title, dbo.tbl_Work_Requests.Work_Request_Rank, This is my stored procdure:- Code: CREATE PROCEDURE FilterProcMain ( @ReferenceNumber varchar(25)=null, @Title varchar(1000)=null, @owner int=null, @status int=null, @team int=null, @lineofbusiness int=null, @requestor varchar(50)=null ) AS Set NoCount ON If (@ReferenceNumber = '') AND(@ReferenceNumber 'N/A') SET @ReferenceNumber = NULL If (@Title = '') AND(@Title 'N/A') SET @Title = NULL If (@owner = '') AND (@owner 1000000) SET @owner = NULL If (@status = '') AND (@status 1000000) SET @status = NULL If (@team = '') AND (@team 1000000) SET @team = NULL If (@lineofbusiness = '') AND (@lineofbusiness 1000000) SET @lineofbusiness = NULL If (@requestor = '') AND(@requestor 'N/A') SET @requestor = NULL /* Variable Declaration */ Declare @SQLQuery AS Varchar(4000) Set @SQLQuery = 'SELECT DISTINCT dbo.tbl_Work_Requests.Work_Request_PK, dbo.tbl_Work_Request_Status.Work_Request_Status_Title, dbo.tbl_Line_Of_Business.Line_Of_Business_Name, dbo.tbl_Work_Requests.Work_Request_Number, dbo.tbl_Work_Requests.Work_Request_Title, dbo.tbl_Work_Requests.Work_Request_Rank, dbo.tbl_Work_Requests.Date_Requested, dbo.tbl_Work_Requests.Work_Request_Requestor, dbo.tbl_Work_Requests.Line_Of_Business_FK, dbo.tbl_Work_Requests.Work_Request_Status_FK FROM dbo.tbl_Line_Of_Business left JOIN dbo.tbl_Work_Request_Status left JOIN dbo.tbl_Work_Request_Tasks left JOIN dbo.tbl_User_Groups left JOIN dbo.tbl_Users ON dbo.tbl_User_Groups.User_Group_PK = dbo.tbl_Users.User_Group_FK ON dbo.tbl_Work_Request_Tasks.User_ID_FK = dbo.tbl_Users.User_ID_PK right JOIN dbo.tbl_Work_Requests ON dbo.tbl_Work_Request_Tasks.Work_Request_FK = dbo.tbl_Work_Requests.Work_Request_PK ON dbo.tbl_Work_Request_Status.Work_Request_Status_PK = dbo.tbl_Work_Requests.Work_Request_Status_FK ON dbo.tbl_Line_Of_Business.Line_Of_Business_PK = dbo.tbl_Work_Requests.Line_Of_Business_FK WHERE (1=1) ' If @ReferenceNumber Is Not Null Set @SQLQuery = @SQLQuery + ' AND Work_Request_Number like %' + @ReferenceNumber + '% ' If @Title Is Not Null Set @SQLQuery = @SQLQuery + ' AND Work_Request_Title like %' + @Title + '% ' If @owner Is Not Null Set @SQLQuery = @SQLQuery + ' AND user_id_fk = ' + @owner +'' If @status Is Not Null Set @SQLQuery = @SQLQuery + ' AND Work_Request_Status_FK = '+ @status + '' If @team Is Not Null Set @SQLQuery = @SQLQuery + ' AND user_group_fk = '+ @team + '' If @lineofbusiness Is Not Null Set @SQLQuery = @SQLQuery + ' AND Line_Of_Business_FK = '+ @lineofbusiness + '' If @requestor Is Not Null Set @SQLQuery = @SQLQuery + ' AND Work_Request_Requestor like %' + @requestor + '%' Execute FilterProcMain @SQLQuery If @@ERROR 0 GoTo ErrorHandler Set NoCount OFF Return(0) ErrorHandler: Return(@@ERROR) GO
Union giving me error msg about distinct use   (234 Views)
when i try to run this following query, i get an error message: Microsoft OLE DB Provider for SQL Server error '80040e14' The ntext data type cannot be selected as DISTINCT because it is not comparable. /resultados_termo.asp, line 176 the query: select * from view_veiculos where ativo='1' and ( nome_marc like '%fiat%' or nome_mod like '%fiat%' or estado like '%fiat%' or cidade like '%fiat%' or ano like '%fiat%' ) and ( nome_marc like '%brava%' or nome_mod like '%brava%' or estado like '%brava%' or cidade like '%brava%' or ano like '%brava%' ) and ( nome_marc like '%2004%' or nome_mod like '%2004%' or estado like '%2004%' or cidade like '%2004%' or ano like '%2004%' ) union select * from view_veiculos where ativo='1' and ( nome_marc like '%fiat%' or nome_mod like '%fiat%' or estado like '%fiat%' or cidade like '%fiat%' or ano like '%fiat%' ) and ( nome_marc like '%brava%' or nome_mod like '%brava%' or estado like '%brava%' or cidade like '%brava%' or ano like '%brava%' ) union select * from view_veiculos where ativo='1' and ( nome_marc like '%fiat%' or nome_mod like '%fiat%' or estado like '%fiat%' or cidade like '%fiat%' or ano like '%fiat%' ) union select * from view_veiculos where ativo='1' and ( nome_marc like '%brava%' or nome_mod like '%brava%' or estado like '%brava%' or cidade like '%brava%' or ano like '%brava%' ) and ( nome_marc like '%2004%' or nome_mod like '%2004%' or estado like '%2004%' or cidade like '%2004%' or ano like '%2004%' ) union select * from view_veiculos where ativo='1' and ( nome_marc like '%brava%' or nome_mod like '%brava%' or estado like '%brava%' or cidade like '%brava%' or ano like '%brava%' ) union select * from view_veiculos where ativo='1' and ( nome_marc like '%2004%' or nome_mod like '%2004%' or estado like '%2004%' or cidade like '%2004%' or ano like '%2004%' ) when i use UNION ALL, i get repeated rows. i need the select distinct on it. please, help.
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'   (133 Views)
I keep getting the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired /admin/functions_web.asp, line 277 This application has been up for 5 years and we never had any problems and all of a sudden we have started getting this error. We have the latest MDAC version. I have increased the scripting and connection time and we still get this error. Please help!
Error converting data type varchar to int error?   (168 Views)
l, hope you can help. got this error: Microsoft OLE DB Provider for SQL Server (0x80040E07) Error converting data type varchar to int. /admin/stores/index.asp, line 520 but no idea what to do what it is line 520 is below: Code: Sub UpdateZoneDisplay() sSQL = "EXEC spUpdateZones " & iStoreID & ",'" & sfk_zoneID & "," & sfk_storeID & "'" SET oRS = oDB.execute(sSQL) istoreID = oRS("storeID") End Sub any help would be brill kind regards MG
ASP syntax error when move from Access to SQL Server   (151 Views)
,
Syntax error converting datetime from character string   (189 Views)
I urgently need some help I have written a .NET windows service that processes some XML's and updates some fields in an SQL Server 2000 DB. It works ok on my workstation. But at the Client's site it causes an exception with the following error: "Syntax error converting datetime from character string" I heard it might have something to do with regional settings for the workstation and SQL Server Language Settings but im not sure. Could somebody please help with this issure!
Microsoft OLE DB Provider for ODBC Drivers error '80004005'   (90 Views)
hi ,i don know shd i ask this question here but i just post because i really cant find a solution,because whole project i done in my local pc but now i transfered to server it face problem and i need to pass up the project today. i got an error message when i try to access the page, www.woodlandssec.sg/index.asp Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver]Access denied for user: 'ODBC@CAPITAL' (Using password: NO) /db.asp, line 11 i included this db.asp in my index.asp and this is the coding. and what if want to host the mysql server on the same server i host the asp pagesall i need is to replace IP for localhost with the IP address of the server this is the whole coding for my db.asp
Triggers on errors   (95 Views)
We have a DB with (what should be) a unique set of data defined by three fields. The database is so poorly designed that there is nothing in place to constrain these items to be unique and something is taking advantage of the fact. I need to identify what. I can set up a constraint forcing the fields to be unique, but, is it possible to set up a trigger that will 1. fire when that constraint is violated 2. write a record to a log table 3. display an error message 4. carry on without inserting the record
Help with login failed error   (149 Views)
hi, On a file server, I set up a connection to my sql server 2005 database, that resides on my machine. I tested the connection and that seems ok. However, when I try to connect to the database with a login, it tells me "LOGIN FAILED FOR USER domain NAME\ server name & "$" I am not sure what to do here. I think I need to add another user, but I don't know how I should do that or what the settings should be. Can somebody help
[Microsoft][SQL Native Client]TCP Provider: Timeout error [258]   (285 Views)
hello , I am new in this pls help me to overcome this error..... Seering this error teh past few days and normal site across a lot of different pages. , i am using sql server 2005 [Microsoft][SQL Native Client]TCP Provider: Timeout error [258] error categorey : Microsoft OLE DB Provider for ODBC Drivers
Insert trigger causes "the data was added to the database but ..." error   (129 Views)
dear friends ! could you please help me ! i have a sql server 2005 database and an ms access project. as soon as i added this trigger to a table SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER trg_insert_building ON tbl_building AFTER INSERT AS declare @buildind_id int BEGIN SET NOCOUNT ON; select @building_id = inserted.id from inserted insert into tbl_bf (building_id, foundation_id) select @building_id as bilding_id, id from tbl_foundation END GO i started getting the following message: microsoft office access: the data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source.
@@Identity - problem getting data back   (145 Views)
I have some asp that should be inserting a shopper into my SQL Server DB. Code: ' call a stored procedure to create a new shopper sql = "execute sp_InsertShopper" set rsShopper = dbShopper.execute(sql) session("idShopper") = rsShopper("idShopper") And here is the Code for sp_InsertShopper: Code: /* Utilized to insert a new shopper into the database */ Create Procedure sp_InsertShopper AS insert into shopper(chrUserName, chrPassword) values('','') select idShopper = @@identity I checked the DB and the shopper is being created but the session is not storing the ID. Any Ideas Matt
CDO error   (137 Views)
I am trying to write a stored procedure that will send an email whenever a certain field in the database is changed. I am using CDO procedures for this. Here is my code (abbreviated) CREATE PROCEDURE dbo.sendMail @from VARCHAR(100), @to VARCHAR(100), @subject VARCHAR(200), @mBody VARCHAR(1000) AS DECLARE @MailID int DECLARE @err int DECLARE @sSource int DECLARE @sDescription VARCHAR(100) DECLARE @sMsg VARCHAR(200) EXEC @err = sp_OACreate 'CDONTS.NewMail', @MailID OUT EXECUTE sp_OAGetErrorInfo @MailID, @sSource OUT, @sDescription OUT SET @sMsg = ' Error # = ' + CAST(@err AS VARCHAR(20)) + '. Description = ' + @sDescription RAISERROR (@sMsg, 16, 1) GO I call this stored procedure through a trigger that looks like this CREATE TRIGGER tr_Categories_1 ON [dbo].[Categories] FOR INSERT, UPDATE, DELETE AS IF UPDATE(CategoryName) BEGIN EXECUTE sendMail 'xyz@abc.com', 'xyz@abc.com', '', 'The field has changed' END However, when I update the table I get the following error Server: Msg 50000, Level 16, State 1, Procedure sendMail, Line 16 Error # = -2147221005. Description = Invalid class string I am not sure why I am getting this error, and documentation on the internet is not helping.
Microsoft OLE DB Provider for SQL Server error '80040e21'   (117 Views)
When I try to insert a record into a table I get the following error. Microsoft OLE DB Provider for SQL Servererror '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done It's in SQL server. Here's the asp code to insert the record. Code: Testcase Anyone who can help I am very new to asp. I tried solving it with a trigger but it won't work cause the record can't be inserted without primary key. Thanx in advance Mojito
ASP script for getting size of database?   (118 Views)
Is there an ASP script that I can use to find the size of my database
getting values   (123 Views)
** COULD A MOD DELETE THIS PLEASE, SORRY COULDN'T FIND HOW TO DELETE THIS THREAD, PROBLEM SOLVED **
probs getting data in datagrid to load   (379 Views)
hi. i am new to sql databases and am currently trying to get the table to populate with data from the database cnCMS. I have been following the ADO.NET step by step text but, when i compile, i keep getting a blank page. below is the method I am using for when the page loads. any ideas what i might be doing wrong any suggestion much appreciated. thanks in advance. Code: privatevoid BindDataGrid() { string sqlQuery = "SELECT AccountID, UserName, Password, " + "Email, ModifiedDate, CreationDate FROM Account"; cnCMSNET.Open(); SqlDataAdapter daAccount = new SqlDataAdapter(sqlQuery, cnCMS); daAccount.Fill(dsMaster2, "Account"); DataGrid1.DataSource = dsMaster2.Tables["Account"].DefaultView; DataGrid1.DataBind(); cnCMSNET.Close(); }
Scheduled job not getting completed on first run(takes more than 13 hrs to complete)   (154 Views)
we are facing problem with Job performance it is taking hours to get completed : Requirement description: Requirement was to create a job which can run every week and can archive the old records (older then 365 days i.e. around 40000 Records) into an archive database and after Successful archival it deletes those from the live database. Implementation Description: I have created a scheduled job which calls "MASTER_SP" stored procedure; MASTER_SP Stored Procedure in turn calls two more stored procedures "ARCHIVE_SP" and "PURGE_SP" in a single transaction. ARCHIVE_SP Stored procedure archives the data from LIVE_DATABSE to ARCHIVE_DATABASE then PURGE_SP stored procedure Deletes that data from LIVE_DATABSE Problem Description: We took a database dump from the live environment and restored on testing environment, made changes to job and started the job for 40000 records(first run), job dint get Completed in 13 hours so I cancelled the job run. Then we tried with these tests and here are the statistics Second run 2500 records: job gets completed in 12 mins and 30 secs. Third run for 11000 records: job gets completed in 1 min and 30 secs. Fourth run 41000 records: Job gets completed in 1 min and 47 secs. Fifth run 113000: job gets completed in 4 mins and 30 secs. Sixth run 283000: job gets completed in 23 mins. We are facing the problem when job is run for first time on the restored database with huge number of records (i.e. around 40000 Records), CPU utilization is reaching to 100% on this machine, Here SQLSERVER process is utilizing CPU a lot. On the same restored database If we run the job with less number of records say 2500, then this job(i.e 2500 Records) gets completes in 12 minutes, and rest of the successive job runs(i.e. for 40000,113000, 283000) gets completed without any problem. statistics are shown above Can anyone say the exact reason why it creates problem on first run, please come up with some suggestions, so that i can implement them and move code into production.
Two seperate records getting mixed up?   (220 Views)
Can somebody please help with this problem I seem to have. I have a shopping cart that connects to the DB and adds orders as records. If two customers click on submit at the same time then both orders become one order. For example the order will consist of one customer's billing address and another customer's credit card details. Really not good stuff, how can I stop that