Hello ,

I cannot connect SQL Server. Getting the following error message: Cannot open user default database. So my question is, how to repair sql server?

Hopefully someone will be able to help me with this.

Thanks in advance

See if this helps You.


https://www.google.com/amp/blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-login-failed-login-failed-for-user/amp/

Oops

benzics:
Are you using OOP mysql or procedural? Are you sure you've created the database you want to connect to?
Connecting using procedural mysqli... $mconn=mysqli_connect(server, user, pass, database) ;if(!mconn) {die(mysqli_connect_error($mconn) ;}

Make sure you've already created the said database

SQL Server => mysqli

kudaisi:


SQL Server => mysqli

Don't get

benzics:

Don't get

MySQL and SQL Server are two different products.

kudaisi:


MySQL and SQL Server are two different products.

Please if you don't know much about something, I advice you keep it to yourself instead of shaming yourself on the internet... SQL takes Mysqli, PDO and others, they are just extensions of SQL...

benzics:

Please if you don't know much about something, I advice you keep it to yourself instead of shaming yourself on the internet... SQL takes Mysqli, PDO and others, they are just extensions of SQL...

mysqli (it is an extension no dispute) is specific to MySQL, PDO can generically access most database supported by PHP.

Why the heck would you want to user mysqli on SQL Server when you have PDO and a SQL Server specific extension ...i.e mssql

benzics:

Please if you don't know much about something, I advice you keep it to yourself instead of shaming yourself on the internet... SQL takes Mysqli, PDO and others, they are just extensions of SQL...

SQL Server as in Microsoft SQL Server. Just so you know, this on that you're being hasty to diss me.

kudaisi:
mysqli (it is an extension no dispute) is specific to MySQL, PDO can generically access most database supported by PHP.

Why the heck would you want to user mysqli on SQL Server when you have PDO and a SQL Server specific extension ...i.e mssql

Well I use mysqli at times and also use PDO.. Surprise! They all work! So I don't know where the base of your argument comes from!!

benzics:

Well I use mysqli at times and also use PDO.. Surprise! They all work! So I don't know where the base of your argument comes from!!

You use mysqli with Microsoft SQL Server...it's alright, and I'm the one shaming my self on the internet? I guess it's no point getting into this conversation with you in the first place.

Enjoy you successful programming career.

kudaisi:


MySQL and SQL Server are two different products.

And you saying they are two different products as if There would be MySQL without SQL?? PDO, MSSQL, MYSQL, etc all use same queries which is SQL! How do you create a table in Mssql, PDO, mysqli? Is it not still "create table name"?? Na wa for all these I too know!

kudaisi:


You use mysqli with Microsoft SQL Server...it's alright, and I'm the one shaming my self on the internet? I guess it's no point getting into this conversation with you in the first place.

Enjoy you successful programming career.

Lol, when did I say I use mysql on Microsoft SQL Server? I'm still searching for that in my post, I didn't mention the server in which I use PDO and mysql, did I?

hello everyone.
I want to say thank you for taking the time to share how to go about fixing this.

Hello,
Each user has a default database. When you connect to computer that is running Microsoft SQL Server, and you do not specify a login database, the default database is used. To avoid the error try this app -https://www.sqlserverrepairtoolbox.com/

It repairs data types, views, procedures, tables, keys, indexes and other objects

There are several reasons due to corrupt or damaged SQL database like Virus attacks, Hard disk surface contamination or damage, Accidental or intentional deletion of data and etc. Download an excellent tool Kernel for SQL Database Recovery Tool. This tool easy to recovers all corrupt or damaged SQL database. It supports all versions of MS SQL server and Windows OS versions. Visit here - http://www.sql.mdfrepair.net

goodwin11:
Hello,
Each user has a default database. When you connect to computer that is running Microsoft SQL Server, and you do not specify a login database, the default database is used. To avoid the error try this app -https://www.sqlserverrepairtoolbox.com/

It repairs data types, views, procedures, tables, keys, indexes and other objects

Hello! This worked for me. Thanks

benzics:

Please if you don't know much about something, I advice you keep it to yourself instead of shaming yourself on the internet... SQL takes Mysqli, PDO and others, they are just extensions of SQL...

Gosh!!! How I hate ignorance. Someone is telling you a product is totally different from another and instead of you to quietly say you made a mistake, you are trying to insult him, saying he should not shame himself.

SQL Server is a Microsoft Technology and is not the same with MySQL.

I'm sure you later researched that and saw they had similar queries so you came here to bend your argument.
And to correct you, they have similar queries but that doesn't mean their queries are the same.

So you go do your research

FincoApps:


Gosh!!! How I hate ignorance. Someone is telling you a product is totally different from another and instead of you to quietly say you made a mistake, you are trying to insult him, saying he should not shame himself.

SQL Server is a Microsoft Technology and is not the same with MySQL.

I'm sure you later researched that and saw they had similar queries so you came here to bend your argument.
And to correct you, they have similar queries but that doesn't mean their queries are the same.

So you go do your research

OK o

kudaisi:


SQL Server => mysqli

Totally misunderstood though...

FincoApps:


Gosh!!! How I hate ignorance. Someone is telling you a product is totally different from another and instead of you to quietly say you made a mistake, you are trying to insult him, saying he should not shame himself.

SQL Server is a Microsoft Technology and is not the same with MySQL.

I'm sure you later researched that and saw they had similar queries so you came here to bend your argument.
And to correct you, they have similar queries but that doesn't mean their queries are the same.

So you go do your research

Actually thought sql server as.. mssql.. Cuz I don't make use of Microsoft technologies though! Just discovered it's still mssql