"The parameter is incorrect" while creating new table

Hi,

I have recently upgraded my OS to Windows 7. After upgrading I have patched my SQL server 2008 to SP1. After that I am not able to create any table from Management studio. I am contineously getting "The parameter is incorrect" from context menu.

Please suggest.

Thanks Shoeb

asked Mar 27 '10 at 03:54 AM in Default

Shoeb
21 ● 1 ● 1 ● 1

please post the code you are running so we can help you

Mar 27 '10 at 07:26 AM Fatherjack ♦♦

Agreed with fatherjack. We need to see the code you are using.

Mar 27 '10 at 11:49 AM CirqueDeSQLeil

(comments are locked)

2 answers:

There's a Microsoft Connect discussion about the same error message (http://connect.microsoft.com/SQLServer/feedback/details/252279/cannot-create-or-modify-tables-in-any-database-the-parameter-is-incorrect).

Last post in that thread claims to have a solution:

"I had this problem but I seem to have fixed it, although I can't get back to the original error to prove what I did was the answer.

The fix: On installation I'd selected "Network Service" as the account SQL Server should run under. I changed this to "Local System", restarted and now I can add tables to diagrams.

I then changed back to Network Service and restarted the service again - and it's still working. One thing I noticed was that when I changed to "Network Service", the services applet told me it had granted "Logon as a service" right to "Network Service". I don't understand how it came to be running as a service before this though.

Ayway it's worth a try - it worked for me."

answered Jun 18 '10 at 09:24 AM