Connect to Server

Hi!

I m using VS2005 and SQL Server 2005 Express Edition For Database.

i want connect to the server with SQL Server Authentication, for this i created a account Name: ( Amit ) and assign the sysadmin security privleges.

whenever i try to connect with my account the below error comes:

TITLE: Connect to Server

Cannot connect to DOTNET\SQLEXPRESS.

ADDITIONAL INFORMATION:

Login failed for user 'amit'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Please help it

Thanks

Amit

Can you post your connection string so that we can see how you are connecting.. Make sure that when you do post it change the server and usernames so that you do not make them puplic...

|||

This is probably due to the server being in integrated mode and the account being a sql login.

Switch the server to mixed mode and you should be able to connect.

-stevengo

---

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Amit,

To determine the source of the login failure, you need to look for the error state in the server's error log. Take a look at this blog posting for more info: http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Il-Sung.

Connect to MSDE with Limited User (not using sql authentication)

I have an MSDE installation that I need to connect to within a C# .NET
project as a Limited User (from the same machine, not via the network)
The MSDE instance is not in sql authentication mode, only windows
authentication. Is this possible? I've used the
'Trusted_Connection=True;' in the connection string, but a login fails
for the user with an error like:
"Cannot open database in login 'testdatabase'. Login fails. Login
failed for wkstn\limiteduser"
Do I need to grant any (additional) rights to the database itself?
Thanks for your help,
Tom
You can=B4t mix up the keyword "USER ID" and Trusted_connection, if you
choose "User ID" (SQL Server auth.) SQL Server will use SQL Server
authentication regardless of the Trusted_connection settings, see more
details here:
http://msdn.microsoft.com/library/de...n-us/adminsql=
/ad_security_47u6.asp
But you can (as you are working with C#) create a impersonated context
and connect with this...
http://www.codeproject.com/csharp/cpimpersonation1.asp
..=2E.and connect with this.
HTH, jens Suessmeyer.

Connect from WIN2000 TO WINNT/SQL2000 using WIndows authentication

Hello,

we develop on Powerbuilder 7.03. We want to use WIndows authentication to connect to a SQL server 2000 with WIN NT 4.0. as OS.
When I want to connect from my PC WIN2000 to SQL2000 with WINNT operating system, I can't ( login failed ).
but when I connect to my PC win2000 to a sql server 2000 with WIN 2000 OS, the connection goes well. ??
Someone encountered the same problem ?? and found a solution ??

Any help will be appreciate.
Thanks in advance.Try this - talks about Windows NT and SQL Server Security

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modadmin/html/deconwindowsntsqlserverlogins.asp|||Originally posted by ascollins
Try this - talks about Windows NT and SQL Server Security

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modadmin/html/deconwindowsntsqlserverlogins.asp

Thanks for your reply.
My connection from NT to WIN2000/SQL SRV2000 is OK. my problem is I can't connect from WIN2000 to WIN2000/SQL SRV2000 using windows authentication with PowerBuilder 7.03.

configuring user security problem!

Hi,
I am new to sql reporting services. I have just installed sql
reporting service sp1. We have our own web app which uses forms
authentication. I have a page where i use reportviewer control (which
came along with samples)...to run a report...there is a separate
physical report server and on that server, for the Reports virtual
directory i have "anonymous access" set. Within this i have set domain
user and password! Now microsot recommends to use "integrated windows
authentication". But as soon as i set it, my web page gives me report
server error that access is denied. I understand that my web page is
impersonating as local\ASPNET user.
I am very confused! can you help me?
I will really appreciate it
Thanks,
SauminIf you use forms authentication you have to create an extension to implement
it. You need to read up on how to do so if you need this capability. It
requires some effort on your part and it requires enterprise edition. I
suggest that you remove anonymous access for now (so you can learn how to
write a report etc and then implement form based security later). For now,
use integrated security (anonymous access and integrated security is
mutually exclusive). To supplement the info on security in the bol I suggest
this link from Scott Allen:
http://odetocode.com/Articles/215.aspx
Bruce L-C
"Saumin" <saumin_patel@.hotmail.com> wrote in message
news:35be972d.0408171307.3e2d9cab@.posting.google.com...
> Hi,
> I am new to sql reporting services. I have just installed sql
> reporting service sp1. We have our own web app which uses forms
> authentication. I have a page where i use reportviewer control (which
> came along with samples)...to run a report...there is a separate
> physical report server and on that server, for the Reports virtual
> directory i have "anonymous access" set. Within this i have set domain
> user and password! Now microsot recommends to use "integrated windows
> authentication". But as soon as i set it, my web page gives me report
> server error that access is denied. I understand that my web page is
> impersonating as local\ASPNET user.
> I am very confused! can you help me?
> I will really appreciate it
> Thanks,
> Saumin

Configuring Database mail with SMTP authentication

I try to configure database mail on SQL Server 2005 (June CTP)
All the services are running under the same domain account which has been also added to corporate Exchange server. When creating a database mail account on SQL Server, I check the "SMTP server requires authentication" check box and enter the account name and paassword. When trying to apply the changes I get the following error:
"An error occured during decryption (Microsoft SQL Server, Error 15466)"

Is there any workaround on this error?

Thanks.
Artem

Check this thread:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1905071&SiteID=17

Configuring Database mail with SMTP authentication

I try to configure database mail on SQL Server 2005 (June CTP)
All the services are running under the same domain account which has been also added to corporate Exchange server. When creating a database mail account on SQL Server, I check the "SMTP server requires authentication" check box and enter the account name and paassword. When trying to apply the changes I get the following error:
"An error occured during decryption (Microsoft SQL Server, Error 15466)"

Is there any workaround on this error?

Thanks.
Artem

Check this thread:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1905071&SiteID=17