mehdi_safa Posted June 6, 2013 Share Posted June 6, 2013 hi friends. i created a sqlexpress database with vs(visual studio2008) and now i want connect to it with php. but thats cant connected.i have this error Connection could not be established. Array ( [0] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'MANSIN\mansin-pc'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'MANSIN\mansin-pc'. ) [1] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 4060 [code] => 4060 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "sch" requested by the login. The login failed. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "sch" requested by the login. The login failed. ) [2] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'MANSIN\mansin-pc'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'MANSIN\mansin-pc'. ) [3] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 4060 [code] => 4060 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "sch" requested by the login. The login failed. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "sch" requested by the login. The login failed. ) ) how to can i solve the problem? best regards. Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/ Share on other sites More sharing options...
cpd Posted June 6, 2013 Share Posted June 6, 2013 Have you installed all the correct drivers? I assume you're using SQL Server 2008 Express. http://www.microsoft.com/en-gb/download/details.aspx?id=20098 Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434370 Share on other sites More sharing options...
mehdi_safa Posted June 6, 2013 Author Share Posted June 6, 2013 (edited) hi, yes, i am installed sqlserver drivers. for useing sqlserver in php i attached 2 extention. extension=php_pdo_sqlsrv_53_ts_vc9.dll extension=php_sqlsrv_53_ts_vc9.dll my xampp worked propery,i havent problem in drivers & php configuration. i have another database (sqlexpress) and i can work with it now,but this created with "full convertor software". but when i create sqlexpress database with vs2008 thats not working. when i use sql managment studio (log in with express) for show all express database , i cant see new database (created with vs2008).but thats created successfull(can i see with windows). now how to can i solve this problem? best regards. Edited June 6, 2013 by mehdi_safa Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434417 Share on other sites More sharing options...
cpd Posted June 6, 2013 Share Posted June 6, 2013 Why are you using Visual Studio to create databases? Its only just registered what you're doing. Use SQL Server Management Studio to administrate the database. Its free to download and is built specifically to manage SQL Server. Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434419 Share on other sites More sharing options...
mehdi_safa Posted June 6, 2013 Author Share Posted June 6, 2013 (edited) thanks for attention. i have sqlserver database backup files(.bak) and this files are for schools (this bak files created with c# application ) and are in school(s) .but schools manager cant work with sql managment studio,i want create a c# app for restore .bak files and convert to express editition and they(school managers) can upload new files to website .(new files are students scores). :happy-04: Edited June 6, 2013 by mehdi_safa Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434461 Share on other sites More sharing options...
cpd Posted June 6, 2013 Share Posted June 6, 2013 Good luck with that! You've got to read Microsofts bak file, how you do that I've no idea, I don't even know if its possible unless you know how it was created which I doubt you do. Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434463 Share on other sites More sharing options...
mehdi_safa Posted June 6, 2013 Author Share Posted June 6, 2013 (edited) i can do,but i havent enough time. thanks for your attention. good luck. Edited June 6, 2013 by mehdi_safa Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434477 Share on other sites More sharing options...
cpd Posted June 6, 2013 Share Posted June 6, 2013 Do you work for Microsoft or something or is the bak file creation public knowledge? First I heard of it... Quote Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434480 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.