SQL About AMO: asp

Showing posts with label asp. Show all posts

Thursday, March 22, 2012

Access a in house sql server from a remote web server

does anybody know how I would create a connection string in asp.net 2.0express to access a database in a different location from the webserver. I have a static IP address on the web server, so I've allowedaccess from the web server through the firewall. I have a user name andpassword, and I've made sure that I have the correct database. Would Iaccess the database using the network IP address and if so, where do Iput it. Thank you to anyone that can give me some insight to thisproblem, I'm very new to asp.net so, about a weeks worth of knowledge,so if you could explain as such I would appreciate it.
Seewww.connectionstrings.com. You put the IP where you normally put the Server name, all else should be the same. That said, hitting a SQL Server on the other side of a firewall may not be the best thing to do.|||thanks
"That said, hitting a SQL Server on the other side of a firewall may not be the best thing to do."
what you recommend then, like I said, I'm pretty new to this. Theproject that I'm working on requires me to create a web form, that ison an outsourced web server, and import the data into our database thatis behind a firewall. Would this be a security issue?

|||Yes, it can be. If SQL Server was perfect, it would not be a problem to leave the SQL port open. SQL Server is not perfect (recall the Slammer virus). So, in the circumstances you describe, perhaps it is your only option. However, I would make very certain that the database server is always patched up to date.sql

Monday, March 19, 2012

Accesing the SQL Server 2005

Hi,

I have a asp.net 2.0 web applicaiton which is connecting to the remote SQL server 2005. When I run the Web app, then Iam connecting to the DB and its displaying the records on the page.

When I browse the same page from the IIS, then iam getting the following error:

"System.Data.SqlClient.SqlException: Login failed for user 'mydomain\user' "

Connection string :

connectionString="Data Source=MySystem;Initial Catalog=DBLive;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>

Please let me know if find accross a solution for this...

Thanks

Vaskam

Verify the 'user' assigned to the Web Servers' AppDomain.

Somewhere, you seem to have assigned the security to 'mydomain\user' -I hope that your domain is NOT called 'mydomain' and that you do NOT have a user named 'user'.

Sunday, March 11, 2012

Accesing database after website deployment

I'm using sqlexpress on development machine and on client server. I'm building a webapp using membership and role provided for asp. In web.config I have definet membership provider and role provider to point to my database.

After web site deployment I get allways message : Failed to update database "c:\app\app.MDF" because the database is read-only, and I'm forced to apply rights for ASPNET. More than that somethimes I must re-register users.

I have tried to modify in web.config with <remove name="LocalSqlServer"/> <add name="LocalSqlServer"...> but I get errors if I try to design my dataset file:"Cannot get web application service".

TIA

Paul

To manipulate the database file, the account used to connect to the database must have read/write permission on the folder where the database file locates.|||Do you get other error message? I guess the problem is permission.|||

I think the problem is when I use SourceSafe, all folders in projects are maded read only.

Sometimes I get some error about NT Serveces does not have right on database, but that eror I have fised from SQL .

Paul

|||

I agree with you.You should add NT Service to access some folders in security.Change your database file property not to readonly.

Friday, February 24, 2012

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
Sam
Hi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegro ups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
SamHi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegroups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
SamHi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegroups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

Sunday, February 19, 2012

About server authentication

Hi,
I've enabled the SQL Server and Windows Authentication mode, and then I
restarted the SQL server. My ASP.NET program can be access the server, but I
found that I cannot login the SQL server using Microsoft SQL Server
Management Studio.
I checked the ERRORLOG on my server, which shows following information. I'm
sure my password is correct.
Logon Error: 18456, Severity: 14, State: 8.
Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
Logon Error: 18456, Severity: 14, State: 8.
Logon Login failed for user 'sa'. [CLIENT: <local machine>]
Error: 18456, Severity: 14, State: 8.
Login failed for user 'sa'. [CLIENT: 192.168.200.1]
Any suggestion for it?
Many thanks~Are you on 2005? If so, is the "sa" account disabled?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Daatmor" <daatmor@.mail.hongkong.com> wrote in message news:OBphWWyWHHA.4028@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I've enabled the SQL Server and Windows Authentication mode, and then I restarted the SQL server.
> My ASP.NET program can be access the server, but I found that I cannot login the SQL server using
> Microsoft SQL Server Management Studio.
> I checked the ERRORLOG on my server, which shows following information. I'm sure my password is
> correct.
> Logon Error: 18456, Severity: 14, State: 8.
> Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
> Logon Error: 18456, Severity: 14, State: 8.
> Logon Login failed for user 'sa'. [CLIENT: <local machine>]
> Error: 18456, Severity: 14, State: 8.
> Login failed for user 'sa'. [CLIENT: 192.168.200.1]
> Any suggestion for it?
> Many thanks~
>|||Yes, I'm using SQL Server 2005, and enabled the "sa" account.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23eA$s%23yWHHA.1396@.TK2MSFTNGP05.phx.gbl...
> Are you on 2005? If so, is the "sa" account disabled?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Daatmor" <daatmor@.mail.hongkong.com> wrote in message
> news:OBphWWyWHHA.4028@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I've enabled the SQL Server and Windows Authentication mode, and then I
>> restarted the SQL server. My ASP.NET program can be access the server,
>> but I found that I cannot login the SQL server using Microsoft SQL Server
>> Management Studio.
>> I checked the ERRORLOG on my server, which shows following information.
>> I'm sure my password is correct.
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <local machine>]
>> Error: 18456, Severity: 14, State: 8.
>> Login failed for user 'sa'. [CLIENT: 192.168.200.1]
>> Any suggestion for it?
>> Many thanks~
>|||Next step would be to change the password for sa to something known, I guess.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Daatmor" <daatmor@.mail.hongkong.com> wrote in message news:ORVoiO6WHHA.1432@.TK2MSFTNGP02.phx.gbl...
> Yes, I'm using SQL Server 2005, and enabled the "sa" account.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23eA$s%23yWHHA.1396@.TK2MSFTNGP05.phx.gbl...
>> Are you on 2005? If so, is the "sa" account disabled?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Daatmor" <daatmor@.mail.hongkong.com> wrote in message
>> news:OBphWWyWHHA.4028@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I've enabled the SQL Server and Windows Authentication mode, and then I restarted the SQL
>> server. My ASP.NET program can be access the server, but I found that I cannot login the SQL
>> server using Microsoft SQL Server Management Studio.
>> I checked the ERRORLOG on my server, which shows following information. I'm sure my password is
>> correct.
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <local machine>]
>> Error: 18456, Severity: 14, State: 8.
>> Login failed for user 'sa'. [CLIENT: 192.168.200.1]
>> Any suggestion for it?
>> Many thanks~
>>
>

Thursday, March 22, 2012

Access a in house sql server from a remote web server

Monday, March 19, 2012

Accesing the SQL Server 2005

Sunday, March 11, 2012

Accesing database after website deployment

Friday, February 24, 2012

About SQL Server 7.0 Developer Edition

About SQL Server 7.0 Developer Edition

About SQL Server 7.0 Developer Edition

Sunday, February 19, 2012

About server authentication

About server authentication

About server authentication

SQL About AMO

Blog Archive

About Me