Visual Studio 2003 and SQL Server Express


i'm attempting connect sql server express instance through visual studio 2003.  when go data connections, choose microsoft ole db provider sql server, fill in parameters server (server name, username, password, database).  when click "test connection" goes through successfully.  when click "ok" create data connection, fails saying username , password should checked.  changed username , password "sa" account created when installed sql server express, , got same successful connection test, failure when tries create connection.  suggestions?  thanks!

i tried connect instance of sql server 2005 express on machine using visual studio 2003 , successful using both sql authentication windows authentication.

when provided sa passoword (sql authentication) , clicked ok after testing connection using "test connection" button, prompted me again sa password. re-entered sa password , able successful connection. there no prompting password when tried connect same server using windows authentication.

can please provide exact error message?

thanks

suroor



SQL Server  >  SQL Server Data Access



Comments

Post a Comment

Popular posts from this blog

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

Getting error when using Excel Destination

Image
i getting error when using   transferring data oledb source  to excel destination i using dynamic file connection means each time new file generated @ desination folder getting error given above path stored in variable @[user::path] :c/admin/ for creating excel file using expression excelfile path: @[user::path] +(dt_str,4,1252) datepart("yyyy",getdate()) +right("0"+(dt_str,4,1252) datepart("m",getdate()),2) +right("0" + (dt_str,4,1252) datepart("d",getdate()),2)+ right("0" + (dt_str,4,1252) datepart("hh",getdate()),2)+right("0" + (dt_str,4,1252) datepart("mm",getdate()),2)+right("0" + (dt_str,4,1252) datepart("ss",getdate()),2)+".xls" now when clicking on exceldestination component mapping getting error ================================= error @ insertingdatafromexcel de...
Read more