linking Asp.net to sql server!

[rcoco]

I'm having a problem with linking an asp.net form to an sql server but
these two are on a different server what would I do to make the link?
when I try run it I get an error (Sql server does not exist or access
denied). Thank you..

 

[Sylvain Lafontaine]

This newsgroup is about ADP and not about ASP.NET.

In your case, probably that you have a problem with the firewall or some
other setting: in its basic configuration, with the SQL-Server set as the
default instance (and not a named instance) and static port used, the port
1433 must be open.

In more advanced configuration (SQL-Server is set as a named instance or
configured for dynamic configuration of the port), the port 1434 and some of
the next ones must also be opened. Take a look at the following
documentation to have more details:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx

You should provide more details: the version (2000 or 2005), the relative
location of the servers (LAN, WAN), type of the installation (default or
named instance), etc.

 

[rcoco]

Thanx a lot It's now connecting properly though I'm getting different
trouble now. My form is supposed to keep updating sfaff whenever there
is a change. but when I try to update it I get this particular
warnning:
SELECT permission denied on object 'staff', database 'bsc_test1', owner
'ISP_EMAIL'. UPDATE permission denied on object 'staff', database
'bsc_test1', owner 'ISP_EMAIL'.
Doyou think there is some thing wrong with thi particular column
because I'm trying to figure out what it mayed be but I don't see what.
By the way I'm using SQLServer 2000.
thank you

 

[rcoco]

thank you very much you've been of much help Sylvain it can now read
it. But now I'm facing more trouble to update the data in the SQLServer
2000. When ever I try to update it I get a message that:
SELECT permission denied on object 'staff', database 'dbname', owner
'owner name'. UPDATE permission denied on object 'staff', database
'dbname', owner 'owner name'.
What Problem do you think this can be . I've tryed to look for the
restriction but ther are non.
Thank you..

 

[Sylvain Lafontaine]

Permission problem: the login account is not dbo or member of the role dbo
and doesn't have the necessary permission to execute the command on the
SQL-Server. Either change the login account used or set the necessary
permissions (easy with Enterprise Manager (SQL 2000) or with SSMS (for SQL
2005, will also work with SQL 2000).

You should post this question on the m.p.sqlserver.server or the
m.p.sqlserver.programming newsgroups if you need more details.