5 edited tags
| link
    Tweeted twitter.com/StackDBAs/status/650976520811487232
4 added 11 characters in body
source | link

I’m a developer, not a DBA (which is showing, I’m afraid). I am trying to run Report Builder 3.0Report Builder 3.0 with SQL Express 2014SQL Server 2014 Express on my home computer (named John-PC) and cannot run my reports.

I accidentally created a user/login combo of user = John-PC and login = John-PC\John. When I try to delete the entry with: Drop Login John-PC\John I

Drop Login John-PC\John

I get an error:

Incorrect syntax near '-'.

I think the problem is the hyphen in my computer's name.

  1. Is there a way to get around the syntax error?
  2. Is there another way to change or drop the user (I tried dropping from sys.server_principals but received an error that I couldn’t make ad hoc changes).
  3. Can I give Report Builder a new user/login name somehow?
  4. If none of the above, can I change the name of my computer to John_PC or will that create a host of other problems that I can’t even imagine?

I’m a developer, not a DBA (which is showing, I’m afraid). I am trying to run Report Builder 3.0 with SQL Express 2014 on my home computer (named John-PC) and cannot run my reports.

I accidentally created a user/login combo of user = John-PC and login = John-PC\John. When I try to delete the entry with: Drop Login John-PC\John I get an error:

Incorrect syntax near '-'.

I think the problem is the hyphen in my computer's name.

  1. Is there a way to get around the syntax error?
  2. Is there another way to change or drop the user (I tried dropping from sys.server_principals but received an error that I couldn’t make ad hoc changes).
  3. Can I give Report Builder a new user/login name somehow?
  4. If none of the above, can I change the name of my computer to John_PC or will that create a host of other problems that I can’t even imagine?

I’m a developer, not a DBA (which is showing, I’m afraid). I am trying to run Report Builder 3.0 with SQL Server 2014 Express on my home computer (named John-PC) and cannot run my reports.

I accidentally created a user/login combo of user = John-PC and login = John-PC\John. When I try to delete the entry with:

Drop Login John-PC\John

I get an error:

Incorrect syntax near '-'.

I think the problem is the hyphen in my computer's name.

  1. Is there a way to get around the syntax error?
  2. Is there another way to change or drop the user (I tried dropping from sys.server_principals but received an error that I couldn’t make ad hoc changes).
  3. Can I give Report Builder a new user/login name somehow?
  4. If none of the above, can I change the name of my computer to John_PC or will that create a host of other problems that I can’t even imagine?
3 added 6 characters in body; edited tags
source | link

I’m a developer, not a DBA (which is showing, I’m afraid). I am trying to run Report Builder 3.0Report Builder 3.0 with SQL Express 2014SQL Express 2014 on my home computer (named John-PCJohn-PC) and cannot run my reports.

I accidentally created a user/login combo of user = John-PCuser = John-PC and login = John-PC\Johnlogin = John-PC\John. When I try to delete the entry with: Drop Login John-PC\John Drop Login John-PC\John I get an error: Incorrect syntax near '-'.

Incorrect syntax near '-'.

I think the problem is the hyphen in my computer's name.

  1. Is there a way to get around the syntax error?
  2. Is there another way to change or drop the user (I tried dropping from sys.server_principalssys.server_principals but received an error that I couldn’t make ad hoc changes).
  3. Can I give Report Builder a new user/login name somehow?
  4. If none of the above, can I change the name of my computer to John_PCJohn_PC or will that create a host of other problems that I can’t even imagine? Thanks in advance, JohnMM

I’m a developer, not a DBA (which is showing, I’m afraid). I am trying to run Report Builder 3.0 with SQL Express 2014 on my home computer (named John-PC) and cannot run my reports.

I accidentally created a user/login combo of user = John-PC and login = John-PC\John. When I try to delete the entry with: Drop Login John-PC\John I get an error: Incorrect syntax near '-'.

I think the problem is the hyphen in my computer's name.

  1. Is there a way to get around the syntax error?
  2. Is there another way to change or drop the user (I tried dropping from sys.server_principals but received an error that I couldn’t make ad hoc changes).
  3. Can I give Report Builder a new user/login name somehow?
  4. If none of the above, can I change the name of my computer to John_PC or will that create a host of other problems that I can’t even imagine? Thanks in advance, JohnMM

I’m a developer, not a DBA (which is showing, I’m afraid). I am trying to run Report Builder 3.0 with SQL Express 2014 on my home computer (named John-PC) and cannot run my reports.

I accidentally created a user/login combo of user = John-PC and login = John-PC\John. When I try to delete the entry with: Drop Login John-PC\John I get an error:

Incorrect syntax near '-'.

I think the problem is the hyphen in my computer's name.

  1. Is there a way to get around the syntax error?
  2. Is there another way to change or drop the user (I tried dropping from sys.server_principals but received an error that I couldn’t make ad hoc changes).
  3. Can I give Report Builder a new user/login name somehow?
  4. If none of the above, can I change the name of my computer to John_PC or will that create a host of other problems that I can’t even imagine?
2 added 6 characters in body; edited tags
source | link
1
source | link