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. 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 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 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. 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. 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 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: 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. 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 i can do,but i havent enough time. thanks for your attention. good luck. 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... Link to comment https://forums.phpfreaks.com/topic/278832-sql-express-database-php/#findComment-1434480 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.