[ Radudzoni @ 11.07.2003. 22:27 ] @
Kada stavim sledeci kod:

SqlConnection conn = new SqlConnection("Initial Catalog=Nortwind;
Server=RADE-JOVANOVIC7\\NetSDK;UID=sa;PWD=;");
.
.
.
conn.Open();

i pokrenem asp.net aplikaciju u breuzeru mi se javi sledeca greska:

Exception Details: System.Data.SqlClient.SqlException:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

a ako u ConnectionStringu stavim Trusted_Connection=true
tada dobijam sledecu gresku:

Exception Details: System.Data.SqlClient.SqlException:
Cannot open database requested in login 'Nortwind'.
Login fails. Login failed for user 'RADE-JOVANOVIC7\ASPNET'

pa se pitam zasto!
[ degojs @ 11.07.2003. 23:58 ] @
Pokušaj da vidiš ovo:

http://support.microsoft.com/d...69/5/87.ASP&NoWebContent=1

Ne zaboravi da restartuješ MSSQL servis.
[ degojs @ 12.07.2003. 00:03 ] @
If the web server and SQL Server are on the same machine...

1. If SQL Server is using Windows Authentication, you have to add
MACHINENAME\ASPNET to SQL Server logins.

2. If IIS is using Integrated Windows authentication and SQL Server is
using Windows Authentication and you are using impersonation in web.config,
you have to add the current user (MACHINENAME\USERNAME) who logged on
Windows to SQL Server logins.


If the web server and SQL Server are on the seperated machines...

1. If IIS is using Integrated Windows authentication and SQL Server is
using Windows Authentication, you have to use impersionation in web.config
and also configure NT Kerberos and Delegation. Delegation is only supported
by Win2k.

2. If IIS is using Integrated Windows authentication, a much simply
solution is to use SQL Server Authentication in SQL Server and specify the
username and password in the connection string.
[ Radudzoni @ 12.07.2003. 01:38 ] @
Hvala za trud!

U medjuvremenu sam pokusao isto samo sa drugom bazom,
takodje jednom od onih sto se instaliraju sa sql serverom
i radi, a nemam pojma u cemu je problem.
No, nije ni bitno vazno mi je da proradi sa bilo kojom.

pozdrav!
[ veljaradenkovic @ 12.07.2003. 15:05 ] @
He he...

Ako je ovo sto kazes onda si pravilno napisao ime ove druge baze...

jer od ove prve nisi nije NORT nego NORTH ko SEVER...
[ byTer @ 12.07.2003. 17:23 ] @
Dodaj u conn stringu "Integrated Security = SSPI;"