What's my login?

Hot Topic

I'd like to get a good book of SQL...
2005 SQL EXPRESS DATABASE BACKUP
Row and Cell Segurity
SSIS as DataSource For SSRS - Failure on Different Machine (Server vs Dev)
packages and data source views do not work?
Error 1 Memory error: The operation cannot be completed because the memory quota estimate exceeds the available system memory.
creating a user with dbo access
Merge join with empty inputs
Users Cannot Connect to SQL Server 2000 SP4 After Applying Hotfix (build 8.00.2148)
Join query

SQL Server

Columns
Using SQL Server 2005 Express in a Windows peer-to-peer workgroup
sql server 2005 SSIS and AS400 connectivity
More Merge Join question
Cannot create a connection to data source !!!! SSRS 2005
upgrading from 2000 to 2005.
Database Mail - Command not Supported error
Webservice Task Input
Custom ControlFlow
See the error log for more details.

What's my login?

Hello,

I installed Visual Studio 2005 and SQL Server Express that comes with it. I have also downloaded Web Data Administrator for database management. What login do I enter to connect to SQL Express via Web Data Administrator SQL Express installed silently together with VS, and I was never asked to provide a default username/password. Any help

PS. I am using Win XP Pro SP2

Thank you

Answer this question

What's my login?

  • TimothyMS

    If you are using Windows credentials, you don’t have to type them in though Windows Authentication is integrated, getting your credentials that you are logged on with. If you want to change the port number (but I guess you don’t have to as the default port number is taken (1433) if no other instance is installed on the machine) you can do that by typing it after the instance name with a comma, so MachineName\InstanceName,Portnumber

    Did you try to administer the SQL Server Express engine with SQL Server Express management Studio It can be downloaded for free from the Microsoft download site.


    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • kkkwj

    When SQL Server is installed through Visual Studio it installs using Windows Authentication only. Therefore, you should be able to connect to SQL Express using your Windows credentials. But you need to be logged into the machine with the same account you were logged in as when you ran the installation.

  • Peter Mortier

    I was provided with a simple solution which works just fine. Whoever has got a similar problem, check this http://msdn2.microsoft.com/en-us/library/ms188670.aspx.

  • jay2006

    Did you try to administer the SQL Server Express engine with SQL Server Express management Studio

    No, I didn't... but I don't think it should be required to simply login

    I'm not sure if you guys understand me correctly. Web Data Admin provides you with 3 fields to access the SQL Server via your browser. The three fields are Username, Password and Server. In the Server field I enter REEPC\SQLEXPRESS and I'm sure this is correct.

    But I really don't know what I need to enter into Username and Password fields. As one of you suggested, I should use Windows login credentials. I am the only user on my machine, and I do not use any password to log into Windows, but I do know my username (I provided it when prompted right after Win XP clean install). Even if I only enter my username in the Username field and leave the Password field empty on the Web Data Admin login page, I still get the same login error.

    As I mentioned, I enabled SQL Express mixed authentication mode via a simple registry edit (I think this is required for Web Data Admin to work).

    Do you guys have any ideas what could be wrong Maybe I need to configure SQL Express itself What settings should I change I have also tried all 3 built-in account types (Local System, Local Service, Network Service) without any positive effect.

  • Ritchie Hughes

    I have tried entering my Windows credentials (I do not use a password, I'm the only user/admin of the machine) and it simply doesn't want to let me in.

    Maybe I need to indicate the port somehow (I have changed it) I have also enabled the mixed authentication mode (a simple registry fix) as per many tutorials found on the net.

    Not sure where the problem is.
  • What's my login?
Answer this question