I did some configuration on Windows Firewall, not sure if I did it correctly, it is still not working, please see the attachments for the screenshots.

Thanks.

Lowell (2/7/2012)

---

it's gotta start with the basics, i think:

since its an express instance, is the checkbox for allow remote connections checked? maybe via the Configuration?

next, and probably the...

Bru Medishetty (2/7/2012)

---

Look in SQL Server Surface Area Configuration. Connect by Instance and see the property for Remote connections. see if the option is set to Local and remote connections?

I...

Too bad, still no one can give a possible solution.

Any clue is appreciated. Thanks in advance.

Finally issue was resolved: I created some fake database files according to the errorlog, "database services" was able to be installed, server is up now. Thanks God it is such...

Thank you for your input, I already read the first KB before, I think it says I need to configure SPN on my local machine. Correct me if I am...

Cause identified, my bad. The query is not correct.

I found this by running the query alone, and immediately realized the object part should be: server.database.dbo.table, I missed database there, when...

As the first step, i'm running this as a query n still fail

I am the admin of the server/db

removing the server name and dbo is no use

It's on the same server.

I did it, but I don't like my code at all, just too ugly, anyway, I post here in case any one need it.

ALTER function [dbo].[fnGetNewCategoryByDocID] (@DocID int, @bitpos int,...

I appreciate your help but honorsly I don't understand your query and I am not sure if you understand my question (sorry for saying that)

Let's say my table1 has this...

representing the data with int is probably not as clear as current varchar:

Each digit represents a record in another table, let me explain here so you can see if my...

anthony.green (12/8/2011)

---

halifaxdal (12/8/2011)

---

Works for majority of the sp and fn but throws out some exception:

Msg 4606, Level 16, State 1, Line 1

Granted or revoked privilege EXECUTE is not compatible with...