Showing posts with label website. Show all posts
Showing posts with label website. Show all posts

Friday, March 30, 2012

I encountered problem after .NET framework upgraded to 2.0 in the server

I posted the question below to this website 6 hours ago, the subject was "SQL server registration failed". I couldn't find this question just now. This is my first time to post a question to microsoft website. Please let me know the related website if the question shouldn't be posted here.(I think it 's related to this site)
URGENT, I need help, thanks.

I installed .Net framework 2.0 in a Window 2003 Server and VS2005 in my PC a few days ago (.NET framework 1.1 is still in the server and VS.NET2003 is still in my PC), SQL server 2000 is with web server together. there is no problem to run ASP.net 2.0 application, the application also can query the database in SQL server.
But I encounter a problem that I can't create new SQL server registration from my PC to the above server. the error msg is "SQL Server registration failed. SQL Server does not exist or access denied ConnectionOpen(Connect())"
There is no problem to connect SQL server remotely before I upgraded .net framework to 2.0 and VS.NET2003 to VS2005.
I checked the SQL service (started), TCP/IP(enabled). I also installed SQL server SP4 in the server, but I still encounter the same problem.
Anybody can help? Thanks


moving to SQL forum.

|||I guess the firewall on the Windows 2003 server doesn′t allow incoming communication on port 1433. Change that and as a stateful firewall Windows will open the outgoing ports for communication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Wednesday, March 28, 2012

I dont know how to connect with Ms Sql

Hello,

I am new at asp.net. I want to design a website using asp.net as frontend and sql database as backend. I am able to connect and add,update as well delete records when I use MsAcess and Asp.net using the following connection strings...
**********
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.mappath("db1.mdb"))
dbconn.Open()
sql="SELECT * FROM table1"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
data1.DataSource=dbread
data1.DataBind()
dbread.Close()
dbconn.Close()
end sub

**********

But I don't know how to connect with Ms Sql.

I have MS SQL Server 2003 in my computer aleady Installed.

Please Tell me the exact code or procedure to make connection with MS SQL Server.

HELP ME!!!!

The equivelent code for connecting to SQL server is:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim dbconn As SqlConnection = Nothing
Dim dbread As SqlDataReader = Nothing

Try
dbconn = New SqlConnection("server=;uid=;password=;database=;")

Dim sql As String = "SELECT * FROM table1"
Dim dbcomm As New SqlCommand(sql, dbconn)

dbconn.Open()
dbread = dbcomm.ExecuteReader()

data1.DataBind()
Finally
If Not dbconn Is Nothing Then
If dbconn.State = ConnectionState.Open Then
dbconn.Close()
End If
End If

If Not dbread Is Nothing Then
If Not dbread.IsClosed Then
dbread.Close()
End If
End If
End Try
End Sub

HTH,
Ryan

sql

Friday, March 9, 2012

I am getting this err msg when trying to logon to my website on the web

HelloI am getting this err msg when trying to logon to my website on the web - on my machine there is no prob, An error occurred while established a connection to the server.
When connection to Sql.S 2005, this failure may be caused by the fact that
under the default settings sql.s doesn't allow remote connection.
(provider :Sql.S Network interface, error:26- Error Location Server/Interface Specified)(the files path is like in the web host s)

You need to configure the SQL 2005 database for the membership schema. Google aspnet_regsql.exe for help on it.

Jeff

|||

Could you check this link to see whether this is the issue?

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277