Re: How to connect to a custom database

"Rinaldo" <zwartehoofdpiet@xxxxxxxxxxxxxxxxxx> wrote in message news:DAFA30B6-78E0-4F39-A0CA-BEF90547C731@xxxxxxxxxxxxxxxx

If I connect to the Northwind database there is no problem, so integrated security must be good

Yes, but IIRC Northwind configures itself automatically to allow the currently logged on user access as part of the installation process.


I always log in as a Windows user in SQL Server if I started it up, no username or passwords.

That's not quite true... When connecting as a Windows user, you most certainly *ARE* using a username and password, specifically your Windows username and password - that's what "integrated security" means...


The database is made by the integrated database wizard in VC#.

The error you're getting indicates that the user which is trying to connect to the instance of SSE doesn't have a valid SSE login.

If you were using a full version of SQL Server, I'd have suggested that you simply set up a trace to see exactly what's happening. Unfortunately, this isn't available in SSE. Therefore, you'll need to download and install this: http://sqlprofiler.googlepages.com/ and set up a trace that way. Then, once you have set the trace running, try to connect again - the trace will show all of the commands being sent to the instance of SSE on which you have configured the trace to run, and that will (almost certainly) tell you what the problem is.


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

.

Relevant Pages

  • Re: How to connect to a custom database
    ... made again a database in VS with a connectionstring made into it. ... When connecting as a Windows user, you most certainly *ARE* using a username and password, specifically your Windows username and password - that's what "integrated security" means... ... The error you're getting indicates that the user which is trying to connect to the instance of SSE doesn't have a valid SSE login. ... If you were using a full version of SQL Server, I'd have suggested that you simply set up a trace to see exactly what's happening. ...
    (microsoft.public.dotnet.languages.csharp)
  • [REVS] XST Strikes Back
    ... Get your security news from a reliable source. ... support for TRACE in browsers and proxy servers. ... never arrives at the web server (of course, if the first proxy server is ...
    (Securiteam)
  • Re: how often do 0-days REALLY happen?
    ... Thanks to the trace, I was able to develop enough evidence ... day - last I heard he was working for a managed security provider. ... and tracking system please see: http://aris.securityfocus.com ...
    (Incidents)
  • Re: Help:How do you trace in this application?
    ... web interface, from database end, I only see one user name, if I ... select username from v$session, I got several app_user, with different ... sid, from the same machine, which is the application server machine, ... In the worst case you simply have to trace all sessions of this user, make your "special" user execute the commands you are interested in and switch off tracing for all again. ...
    (comp.databases.oracle.server)
  • Re: New Web Vulnerability - Cross-Site Tracing
    ... > Security has unmasked a flaw in one of the Web's cornerstone protocols ... TRACE is IMHO a silly feature, but it's unrelated to the real problem. ... a simple GET request sent by XMLHTTP could ask for a page from ... TRACE would be a danger if there were a legitimate way to persuade a browser ...
    (Bugtraq)
Quantcast